FAST LOAD SET RECORD in Mainframe batch jobs

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

FAST LOAD SET RECORD in Mainframe batch jobs

Rate Topic

Display Mode

Topic Options

Author

Message

vanathi

Posted 5/9/2008 10:11:15 AM

Forum Newbie

Group: Forum Members
Last Login: 8/12/2008 1:27:00 AM
Posts: 3, Visits: 18

Hey,

Could anyone let me know whether 'SET RECORD' command in FAST LOAD can be used in Mainframe Batch jobs

Post #11407

Fred Pluebell

Posted 5/12/2008 9:15:46 PM

Supreme Being

Group: PAC and SFT Members
Last Login: Yesterday @ 8:28:12 PM
Posts: 298, Visits: 364

No. Channel attached (mainframe) clients always process logical records as if
SET RECORD UNFORMATTED
had been specified.

Post #11416

vanathi

Posted 5/22/2008 2:33:36 AM

Forum Newbie

Group: Forum Members
Last Login: 8/12/2008 1:27:00 AM
Posts: 3, Visits: 18

Thanks fred! My requirement is to fastload a tab delimited text file. Is it possible? Also can you give a sample for fastloading a CSV file as well

Post #11542

SHEEBA

Posted 5/29/2008 6:59:31 AM

Forum Member

Group: Forum Members
Last Login: Today @ 6:44:39 AM
Posts: 28, Visits: 97

.set record formatted

.set record text '|'

.set record unformatted

SHEEBA

Post #11648

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 2:27pm