DSXchange

OK, I think I just discovered why ODBC and Oracle 10g won't work. It is quite simple: There is no ODBC driver for Oracle 10g. I've been using the Oracle Wire driver and it does not work. Maybe I'll try the non-wire driver just for kicks.

Larry

Why not go native? Because the native Oracle OCI stage does not support "Long" data types. Sure they should be converted, but we can't stop the world until that happens! I have used ODBC with Long data before Oracle 10g, but can't read such data in 10g. Actually, I can't read any 10g table...

'M_FTP_MXG2000_Read_Lnk.PARAMETER_NAME' needs to be the actual parameter name, not an input link which contains the parameter name. The parameter value would be read from the db in a db stage and passed into the Transformer where it can be accessed. And yes, you do need an output from the Transforme...

I don't have any answer here, but I can sympathise. I have a similar situation where the column generated SQL gets an "invalid column" error, while the exact same SQL runs fine as user generated. I even exported and imported the job design and the same thing happened. Let us know if you fi...

I have several jobs which do this. Use an appropriate db stage to read the parameters from the database. Then, in the Transformer have a derivation something like this: If UtilityGetRunJobInfo(UtilityRunJob('JobName', 'Parameter1=':value1: '|Parameter2=':value2 : '|Parameter3=':value3 : '|Parameter4...

Do the following: sign on as dsadm, then cd `cat /.dshome` This will take you to the dshome directory. dsenv is there. I would recommend making a copy before changing it. Remember that you must bounce the DSEngine in order for changes to dsenv to take effect. From the dshome directory: bin/uv -admin...

You will also have to change the dsenv file to specify the new Oracle Home and LibPath.

Details can be found in the Oracle OCI Plug In Manual.

We just did this and have experienced no problems at all.

Larry

Actually no. That will ultimately be done I expect, but just to expedite testing, I set it in the script. (I was trying to get away for a week and took any shortcut I could!)

Larry

Thanks Ray for the suggestions. I really had not even thought about using the at command and was about to give it a try when I thought of one other thing. That was that it seemed that there must be some kind of environmental difference. After looking around it turned out that $HOME was not set when ...

What more can I say? The AIX shell script executes FTP on order to transfer multiple files from a Novell server, using .NETRC for user authenitcation. When run directly from a Unix command line, it works like a champ. When run from a job sequence Execute Command activity, it gets "Intruder Dect...

Actually you can use a text editor to change/replace encrypted passwords. We do it fairly often using UltraEdit (a Windows program). The trick is to know what the encrypted passwords look like. This is easily accomplished by writing a dummy job which contains both the old and the new passwords as en...

Although I have looked a hundred times for how to tell Aggregator that the input is already sorted, I didn't see it until I for the hundred and first!

Sorry folks.

Larry

I don't see how pre-sorting data will do any good as there is no way (that I know of anyway) to tell Aggravator that the data has already been sorted. Some parts of DataStage are pretty good, but none are clarvoiyant (sp?).

Find a solution outside of Aggragator!

Larry

Check your /tmp directory also.

But, I couldn't get around this problem and had to design a solution that did not include the Aggravator stage.

Good luck. (Great error msg isn't it?)

Larry

1. Extract all (or some portion if you can predetermine what portion you will need) data from your target table and create two hash files: KeyHash with only key fields, and CDCHash with all fields (and with all defined as key fields). 2. To determine if a row already exists, do a lookup against the ...