Sql*Loader option PRESERVE BLANKS
Moderators: chulett, rschirm, roy
-
AGStafford
- Premium Member
- Posts: 30
- Joined: Thu Jan 16, 2003 2:51 pm
-
powerinmind2
- Participant
- Posts: 16
- Joined: Wed Nov 26, 2003 5:42 am
SQL*LOADER
Hi,AGStafford wrote:One option is to have DS create the CTL file once. Change it manually then use that version in the future. Ignore the one created by the job in the future.
thanks for your solution, but this isn't good for me. Also, i think that Datastage have a very big problem!!!
Is not possible that DS cannot create CTL file with ALL Oracle option!!! DS isn't completely compatible with Oracle!!! THAT'S INCREDIBLE!!
I think that Ascential should create a patch for this problems!!! Absolutely!!!
Massimiliano
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Which version of the ORABULK stage are you using? Actually it won't matter very much, all versions are very old, and not written to the DataStage plug-in API. In fact the first version was written in DataStage BASIC - may still be (I haven't checked lately).
It probably is due for an overhaul; Ascential will require you to make a business case if you want them to do it ("it's not actually broken so it doesn't need to be fixed"). You could always write your own.
It probably is due for an overhaul; Ascential will require you to make a business case if you want them to do it ("it's not actually broken so it doesn't need to be fixed"). You could always write your own.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi,
I don't have DS available in this station, but I had something similar with Sybase control file a while back.
did you check if there is an option to add user commands in the file generated?
(in one of the stage options somewhere)
that solved my issue then.
IHTH
I don't have DS available in this station, but I had something similar with Sybase control file a while back.
did you check if there is an option to add user commands in the file generated?
(in one of the stage options somewhere)
that solved my issue then.
IHTH
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
powerinmind2
- Participant
- Posts: 16
- Joined: Wed Nov 26, 2003 5:42 am
Hi Roy,roy wrote:Hi,
I don't have DS available in this station, but I had something similar with Sybase control file a while back.
did you check if there is an option to add user commands in the file generated?
(in one of the stage options somewhere)
that solved my issue then.
IHTH
i have checked the option possible into user commands but there isn't nothing for solve this problem!!!!
I think very seriously that i have found a BIG hole into Datastage! It isn't 100% Oracle compatible!!
Massimiliano
I think you are looking at this backward.powerinmind2 wrote:i have checked the option possible into user commands but there isn't nothing for solve this problem!!!!
I think very seriously that i have found a BIG hole into Datastage! It isn't 100% Oracle compatible!!
Oracle is non-standard in the way they handle data.
Now I need to ask you this: Are you talking about the Parallel version of Oracle stage, or the Server version of ORABULK?
-T.J.
Developer of DataStage Parallel Engine (Orchestrate).