SQL loader control file issue

nadeemhari · Post by **nadeemhari** » Fri Aug 05, 2011 9:16 am

I am new to Datastage. Can some one tell me how to call sql loader control file to load a fixed length file through data stage.
Also how can we load zoned decimal data type.

Your help is appreciated.

Thanks
Nadeem.

chulett · Post by **chulett** » Fri Aug 05, 2011 11:14 am

We start by not hijacking someone else's post, so I've split your question out into one that you now own and can control. Note that I had to guess your version and O/S, correct those if they are wrong.

Can you post more details for your issue? What you are attempting to load, the ctl file it is generating for you and what exact errors you are facing would help as a starting point.

nadeemhari · Post by **nadeemhari** » Fri Aug 05, 2011 11:50 am

Thanks. I could find a way to start my own message.

Actually I am trying to load a fixed length file which have zoned decimal data type( e.g. {00000{000000478I02000000084{000000027E000000060)
I do not know how to load these values through data stage. In oracle sqloader we can load them using zoned data type. So I thought if we can use sqlloader contrlol file in data stage then I can change this control file to load this file.
Also can you please let me know what are steps to load fixed length file by giving data positions 1-17 should go to this column etc.

Thanks
Nadeem.
euote="chulett"]We start by not hijacking someone else's post, so I've split your question out inene that you now own and can control. Note that I had to guess your version and O/S, correct tehose if they are wrong.

Can you post more details for your issue? What you are attempting to load, the ctl file it is generating for you and what exact errors you are facing would help as a starting point.[/quote]