|
View previous topic :: View next topic
|
| Author |
Message |
venkyca
New User
Joined: 02 Mar 2007
Posts: 1
Location: minnesota
|
|
|
|
Hi,
I have to extract a query result table to a text or csv file with a specified record length given by a record layout. I can extract data but the record length is gretaer than the required output record length because of some extra spaces or nulls in between fields.
I have a fixed record format for the ouput file. How do I specify the exact length in AQT so that it matches the target record layout and that should not conatin any extra characters in between.
Thanks
VK |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Use a Programming langualge that allowes you to "exact length in AQT so that it matches the target record layout and that should not conatin any extra characters in between". |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Are you creating the "output" file on the PC? If i recall correctly, AQT is pc-based with the ability to access database tables on multiple platforms (win-based, unix, and mainframe).
What you may have is the full size of the data - including trailing blanks.
Where are the extra characters? Please post what you are getting and what you'd prefer. Also, please post the attributes of the output file. |
|
| Back to top |
|
|
|
|
