Select * from library/file in DB2
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts
Page 1 of 1
Hi.
When running SQL in DB2..using the simple select * from library/file, it will display the record name first...not as RRN 1, but as a header I guess. When this is done in GA, encrypted in and ftp'd to our vendor, they get that header as well. The first record cannot be this record name header, but a header record must be diplayed first.
Does anyone know how to NOT send this record name header? Sample I am sending is MAMREC is being sent as first line, and RRN 1 is H550944xxxxxx etc.
[img]Position to line . . . . .
....+....1....+....2....+....3....
[b]MAMREC [/b]
H5509440000000088 20120315R
[/img]
When running SQL in DB2..using the simple select * from library/file, it will display the record name first...not as RRN 1, but as a header I guess. When this is done in GA, encrypted in and ftp'd to our vendor, they get that header as well. The first record cannot be this record name header, but a header record must be diplayed first.
Does anyone know how to NOT send this record name header? Sample I am sending is MAMREC is being sent as first line, and RRN 1 is H550944xxxxxx etc.
[img]Position to line . . . . .
....+....1....+....2....+....3....
[b]MAMREC [/b]
H5509440000000088 20120315R
[/img]
- Support Specialist
- Posts: 91
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
-
After doing your SQL query, are you writing the data out to a CSV file?
If so, the advanced tab has a setting to ignore the header.
If so, the advanced tab has a setting to ignore the header.
2 posts
Page 1 of 1