DSXchange

I hope these 16 won't be hard to create again, but to avoid this in the future go to Kim Duke's site:
http://www.duke-consulting.com/DataStage_Tips.htm

and download scripts.zip and schedule backup of your project(s) on a Windows machine.

Files sometimes just disappear. Shit happens...

So, have you tried the option I suggested to you in this thread? http://www.dsxchange.com/viewtopic.php?t=109257 If it doesn't help, you will probably have to remove Oracle 9. I don't know how to completely remove it without clean reinstall of Windows because it leaves to much registry entries after...

When you were writing to the database were you using load method?
Did upsert work?

Forgot something: It also makes difference if your target field is char or varchar2. It even makes difference if "not null" constraints are enabled or disabled while loading. This is what I remember from fiddling with this, but in the end I thought it's easier to loose the spaces and make ...

Look at this to prove you're not crazy: http://www.dsxchange.com/viewtopic.php?t=108979&highlight= And try APT_ORACLE_LOAD_DELIMITED. It involves delimiters which you can change and, unfortunately, double quotes which you cannot change. Therefore, if you have double quotes in your data, you're o...

What about changing all back to 9i when Datatstage "thought" everything was 9i? What thing didn't work then?
There are always some issues with multiple Oracle homes and third applications picking which one to use.

The following applies if you are using Load method to load an oracle table: You have one version of SQL Loader on Datastage machine trying to load to an oracle database of a different version. There are combinations that work, and combinations that don't. What exactly are those, I can't remember, bu...

I'm afraid not. Version control will also be slow.

What kind of unix do you have? Here we have HP UX. And could you give the link to this trial?

If you paste your insert and update statement into SQLplus from Oracle stage and replace the orchestrate.something with some values, do you get disconnected? Maybe your DBA could help and examine your session from Datastage (he could see the exact SQL statement that Oracle can see) and see what happ...

Just curious:
Datastage 8 for UNIX is available?

Do you have some other job that works well with this database?
Can you read some data from the database using Datastage(try an Oracle stage with an output link and then click view data)?
Can you connect to the database from the Datastage machine using SQLplus?

In the documentation you should find something called "Stored procedure stage". It is not installed by default. You will need to install it to every project in which you need to use it. We have been using it successfully for a while. I hope this works in Windows and server edition too. We ...

We have been struggling with this dreadful error for two years now. It happens randomly an occasionally in almost any sequence. No matter how many jobs starting simultaneously. And we are pretty sure our DataStage machine doesn't hit its limits when this happens. The fact that most of the time every...

You have spaces in your parameter => It gets double quotes (only when scheduled). This is exactly how it works!
Is this a feature or a bug? I don't know, but you have to loose the spaces.