Search Results

Hi Robin,

Firstly, i have a SQL script.
I'm doing a "EXPORT TO SL_JUN_07142014.asc of del modified by coldel|" before the SQL script so that, the columns are separated by a "|".
Then since,...

All i tried was:
1. Create a Jun_07142014.sql file, with the following code.
EXPORT TO SL_JUN_07142014.asc of del modified by coldel| messages SL_JUN_07142014.expmsg
SELECT...

Hi,

I have a DB2 UDB 9.7 SQL script, as follows:
I need to pass the script into Unix and generate a fixed length file from this.

Can someone kindly provide a script to achieve it?

...

Awesome!! Thanks! that was wonderful :)

Hi,

I have a text file (attached the sample). I have also, attached the way the way the files need to be split.
We get this file, that will either have 24 Jurisdictions, or will miss some and...