Perfect.Thank you for the quick responses.Much appreciated.
Thanks for the prompt reply.I didn’t realise SQL was allowed.Tried the above though with no success but using SQL without the date works fine. So still an issue with format i assume.[&SELECT 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||’.pdf' FROM dual]Works perfectly but no date. Thanks
Worked fine for me but just need to change the application owner on the two table references to suit your company row_number() over(PARTITION BY ith.contract, ith.part_no ORDER BY ith.transaction_id) row_id FROM inst1app.inventory_transaction_hist ith LEFT JOIN inst1app.mpccom_accounting ma ON ith.accounting_id = ma.accounting_id Hope this helps
Is there a way to update this using SQL. the table space is read only
Thanks Jens for the prompt reply Works perfectly
Our applications owner has been changed from IFSAPP to PRIN1APP
Thanks for the reply but still exactly the same.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.