All Forums Tools
Gans 4 posts Joined 03/14
09 Mar 2014
FASTLOAD SCRIPT ISSUE

I have an issue with my fastload script. It loads the data into my target table however the characters like '*' in my fixed width flat file  need to be converted to null.
My client  requirement is that multiple '********' in fixed width file need to be treated as null while loading to table . Could anyone help on this.
Thanks .Appreciate your answers.

ThomasNguyen 30 posts Joined 04/09
10 Mar 2014

Hi Gans,
Not sure about your question but if records in the input file, have a field with value '********' and you want to load it as a NULL, then you can use NULLIF clause in the DEFINE command.
Thomas

SuSeSi 61 posts Joined 10/08
10 Mar 2014

Use NULLIF command in Fastload. Check Manual for details.

-Sudhansu

Gans 4 posts Joined 03/14
10 Mar 2014

 trans_id (char (28) , NULLIF = '*' ),
 item_name (char (127), NULLIF ='*'),
 
This is how i am defining my statement ... but still the table is loaded with  '*******' from the fixed width file. 

feinholz 1234 posts Joined 05/08
10 Mar 2014

FastLoad does an exact match, byte-for-byte.
It is not pattern matching.
So, if you field will have 7 '*'s, then your NULLIF clause must have 7 '*'s.
If each row will have a different number of them, then the NULLIF feature will not work.
 

--SteveF

Gans 4 posts Joined 03/14
11 Mar 2014

Thanks feinholz. It really works..  One problem is i do have some columns which has more 127 '*' loading to varchar(127).
I tried using 127 '*' in NULLIF statement. 
Got the error :"Nullif value too long for column:     "
 Is this can be solved ?

ThomasNguyen 30 posts Joined 04/09
11 Mar 2014

Currently, FastLoad supports NULLIF character value up to 80 bytes.

feinholz 1234 posts Joined 05/08
11 Mar 2014

As indicated above, the match has to be exact (in content and length).
With VARCHARs that is difficult because each row may have a different length for that field.
Thus, the NULLIF feature does not work well with VARCHAR fields.

--SteveF

Gans 4 posts Joined 03/14
11 Mar 2014

Thanks Thomas and feinholz. This really helps.

divyagolla 22 posts Joined 02/14
12 Mar 2014

Fast export script issue :
I have to export a file having more than a crore records. whem am running the fast export script i am getting below error. Kindly advice.
UTY4014 : Access module error '34' received during 'write operation: 'pmunxWBuf; fell error ( system error message dectectd : 27 )
Error attempting to write file

sgarlapa 88 posts Joined 03/13
12 Mar 2014

Is this error after writing some data on to file or initiatlly even before starting the export.
Ensure you didn't keep this file open before you start your fastexport.
 
 

krishaneesh 140 posts Joined 04/13
12 Mar 2014

Has this error occured when a restart of the job was done. if so clean out the error tables, restart log table and do a fresh restart.

divyagolla 22 posts Joined 02/14
13 Mar 2014

Thanks for your response Krishaneesh/sgarlapa.
Around 70 lakh records got exported to file..  but in log file i can see the above error. Is this because of space constraints in UNIX ? or script issue.? Please advice.

You must sign in to leave a comment.