Redbrick
Moderators: chulett, rschirm, roy
Redbrick
I created a job with input as sequential file and do a bulk load in one of the tables in redbrick database. So, I used the option of Redbrick bulk load stage with the option Load Automatically = Y. The job runs without any errors. But in the database, but it's creating .bat files and .dat files and it's not creating TMU files
Expecting the reply at the earliest.
Thanx in Advance
Expecting the reply at the earliest.
Thanx in Advance
Welcome Aboard
Confirm this for me, does the data get loaded or not? Also, the control files will be created in the directory you provided in "Control File Directory" property. Also, what is the file name that you are providing, if you are not providing any name it will default to table_name.tmu
![Cool 8)](./images/smilies/icon_cool.gif)
Confirm this for me, does the data get loaded or not? Also, the control files will be created in the directory you provided in "Control File Directory" property. Also, what is the file name that you are providing, if you are not providing any name it will default to table_name.tmu
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Redbrick
yeah it's loading the data into table but it's not genrating tmu files under Control File Directory. even i tried without passing Control File Directory
in this case it's genrating .dat files and .dat files not tmu files .
Thanks
in this case it's genrating .dat files and .dat files not tmu files .
Thanks
Redbrick
yeah it's loading the data into table but it's not genrating tmu files under Control File Directory. even i tried without passing Control File Directory
in this case it's genrating .dat files and .dat files not tmu files .
Thanks
in this case it's genrating .dat files and .dat files not tmu files .
Thanks
Check for that file in your default project directory. Maybe its sitting there somewhere. Also, did you provide 'Y' for the property "Remove intermediate data file"? Try with 'N'.
If nothing works then set Load Automatically to 'N' and then go to the control file directory and see if it really gets created there or not.
If nothing works then set Load Automatically to 'N' and then go to the control file directory and see if it really gets created there or not.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Redbrick
HI
If i not pass Custom Control File Name it's genrating tmu file with the name of databasename_inputtablename.tmu
but i pass Custom Control File Name it's not genrating TMU file but it's genrating all files such as .bat,.sql,.dat
please can u help me
Thanks
If i not pass Custom Control File Name it's genrating tmu file with the name of databasename_inputtablename.tmu
but i pass Custom Control File Name it's not genrating TMU file but it's genrating all files such as .bat,.sql,.dat
please can u help me
Thanks
Hi
no buddy i got the answer if you wants pass user defined name for tmu file. in that case first run the job without passing any name for tmu it will genrate default name. and rename that file which name u want and use that name in u r job and run it it will creating tmu file. it means it's should expect tmu structure in the control directory.
![Smile :-)](./images/smilies/icon_smile.gif)
![Smile :-)](./images/smilies/icon_smile.gif)