DSXchange

Guys, The above warning was issued in the log for a job that then continued to completion successfully. The warning appears on four consecutive lines just before the log entry for the Starting Job... message. So far Ive not found any averse effects from the warning. I would be grateful if someone ca...

I had the same problem a few days ago with Oracle9i and a kind soul told me that the following works: call StoredProcName(); And it worked! Thanks to Aedla Phaneender! Regards, Eric Mortensen, ericm@objectware.no -----Original Message----- From: Shawn Ramsey [mailto:SRamsey@starbucks.com] Sent: Thu ...

Given that the only thing changed is the Solaris release, Id have to suspect that. What is the exit code from cat when you run it from the command line? You can find out by executing the cat command then executing: echo $? ----- Original Message ----- From: amcguinness@qbe.com.au Date: Fri, 25 Oct 2...

Greetings We are on DS Version 3.6 running on Solaris 2.7. Upgrade in progress. We have just upgraded to 2.7 from 2.6. We have a routine that concatenates files using DSExecute to run the UNIX command "cat -s file1 file2 >> file1". DSExecute returns the SystemReturnCode parameter. This is where the ...

This is, iirc, one of the features added to version 5.2 of DataStage.
--
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup

We had a similar experience with DataStage 5. Some suggestions... 1. If you load the column definitions while in the transform stage rather than in the OCI stage (ie at the other end of the link), it doesnt bring in the derivations. 2. If you make sure the table name field in the OCI stage has the f...

All, I am trying to call a stored procedure to extract data into some temporary tables that then will be extracted from. The problem that I am having ii that DataStage uses semi-colons as a delimiter for statements and I need one in my stored procedure call. Is there any way to escape the semi-colon...

Hi everyone, We are presently migrating from DataStage 4.1 on NT to 5.1 on Windows 2000 and we are experencing problems with table definition in the source tables. In the jobs the definition of the source table columns is for example CUSTOMER_KEY and the derivation is SCHEMA_NAME.TABLE_NAME.CUSTOMER...

Yes. We had to remove those derivations to make it work. If anybody has any other solution, do let me know as well Gopal "Sylvain Guilbault" cc: Subject: derivation problem migrating to 5.1 10/24/2002 11:35 AM Please respond to datastage-users Hi everyone, We are presently migrating from DataStage 4...

Or you may find youve forgotten to mark the key column as a key in the second job, that can cause some interesting behaviour. -craig "Evens, Johannes" 10/24/2002 08:39 AM Please respond to datastage-users To: datastage-users@oliver.com cc: Subject: View data I load a hashfile from a sequential File....

we have used the DataTypePicS9 routine, and we get the sign - in the output. Kasia At 14:20 24/10/2002, you wrote: >Question for the forum, > >Can DataStage handle being given an OUTPUT record layout that contains >what Cobol calls "numeric edited items". Does DataStage know what to do >when asked t...

Hi Johannes check the definition of your hash-file and see if you have 0 in the position field. What could happen is that your view data as swap same field, but this doesnt affect the execution. Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@Novabase.PT Tel (NB) : 35...

I load a hashfile from a sequential File. With "View data" I can see all data. I use the hashfile in another job. With "View data" I cant see the last column (only the column name). Do anyone know the reason ? Thanks for help. Johannes Evens Deutsche Telekom T-Com Zentrale Dipl.-Ing. Johannes Evens ...

Hi ppl i have several jobs that use the same hash-file if i made the pre-load to memory i can access to the hash-file in memory and use it in each jobs ? best regards Rui Soares > Rui Miguel Soares > NOVABASE - Business Intelligence > Mail : Rui.Soares@Novabase.PT > Tel (NB) : 351 21 383 65 92 > Tlm...

Question for the forum, Can DataStage handle being given an OUTPUT record layout that contains what Cobol calls "numeric edited items". Does DataStage know what to do when asked to move/assign data to a numeric edited item such as PIC +9(3)v99? When using the SDK functions/routines that transform a ...