×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Fast Load Help!!!

Fast Load Help!!!

Fast Load Help!!!

(OP)
is it possible to use the file created from bteq export in fast load... i mean suppose i create a output file from bteq

say

.export data file=test.dat;
select * from test_table;
.export reset;

can i use the file created "test.dat" in fastload for populating into tables....

thanks a lot for ur time..

regards

sridharan

RE: Fast Load Help!!!

yes, you can use it as a input for fastload or multiload

RE: Fast Load Help!!!

(OP)
hi tdsmart,

thanks for ur reply.... how do i specify that file as input in fastload or multiload... may be some syntax might help....


TIA

sridharan

RE: Fast Load Help!!!

(OP)
tdsmart,

thanks a lot.... i'm able to use it as input for fastload or multiload

regards,

sridharan

RE: Fast Load Help!!!

(OP)
tdsmart,

it worked for one table(with fewer columns) but i got into problem when i tried to use it for another table...

this is the error i get in fastload....

**** 10:11:45 Number of recs/msg: 241
**** 10:11:45 Starting to send to RDBMS with record 1
**** 10:11:45 Bad file or data definition.
**** 10:11:45 The length of: REMARKS in row: 1 was greater than defined.
              Defined: 200, Received: 8293

the file was created from bteq like this

.export data file=c:\data.dat;
select * from mytable;

in the define part of fastload i've given the exact datatype for the variables as present in the dumped table but for timestamp(0) fastload
gives me a error so i changed it to varchar(20).... is that to do with this error.... one more problem i foresee is the original data might contain
some columns which have null value... will exporting it as indicdata will solve the purpose.....

thanks for ur answers

sridharan

RE: Fast Load Help!!!

(OP)
hi tdsmart,

i'm able to use the input file created from bteq export to work with Multiload but for some strange reason FastLoad is bugging me down.... if the tables column doesn;t contain date or timestamp itz working in FastLoad but when it contains some Date columns and Timestamp columns itz giving me an error......

Thanks for any help!!!!!

regards

sridharan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close