I have created a quick report and added CHR(9) in the select, for exampleselect CHR(9)||customer_no from &AO.customer_order_line, this will also solve another issue when long numbers for examlple “1020019393400100” are formatted in excel to 1,02002E+15
I completely agree with the previous proposals, but here is a slightly "dirtier" solution. It is possible to change the maximum number in the user profile whatever number, in example below to 200 000 rows. However, this will prevent the user from accessing Options since an error message is displayed in the client informing that the value is invalid. My recommendations is to only use this if migration jobs or external files are not an option. Error example:
Old question but for information it is possible to dynamically name the created file in these ways: &DATF Date in same dateformat as migration header &DATE Date in format YYYYMMDD &USER The User name of the current user &GUID Guid &TIME Time in format hh24iss &SEQN Sequence Number
Already have an account? Login
No account yet? Create an account
Enter your 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.