DSXchange

You must check the box that says create file. By default it will only create if it does not exist. If you click on the options button there are a number of setting that you can specify. One at the bottom you can check if you want DS to delete the file everytime and recreate. There are also some othe...

This is a topic for an orphaned message.

We did use Merant ODBC driver to connect to Progress 43E (if i rem correctly!). A datastage job read data through this data source and loaded it to Oracle 8.1.7. Configuring the ODBC requires some skill and may take time. once done its a beauty. Then in the datastage job, check the select sql that i...

My apologies to the group.
In some previous emails ive suggested using certain universe system commands which should only be used as a last resort and should ojnly be executed from the uv account.

Hello Luc,

witch plattform did you use?

best regards

Udo

This is a topic for an orphaned message.

Hi Radha, i think u r speaking about DBMS error code. There are output link variables applicable to link and can be used in the constraints and in the derivation: linkname.SQLCODE -----> The SQL error code linkname.DBMSCODE ------> The DBMS erro code You can find more info in Datastage help online. ...

Hi all,

does enyone know if its possible to emulate the pre-load in memoy option using hashed file in DataStage Basic? In other word, may I load records contained within an hashed file in a kind of array, and use it in the same way of an hashed file (access by key etc.)?

Regards,

Alessio

Hi Scott We have a site extracting from progress and loading into Oracle. There is no problem with odbc just the setup is tricky. The extraction is not that fast. -----Original Message----- From: Scott.Burnett@noswa.co.uk [mailto:Scott.Burnett@noswa.co.uk] Sent: 19 February 2002 04:55 To: datastage-...

Peter Oates wrote: Whe I try UNLOCK ALL, I get the message : Verb "UNLOCK" is not in your VOC. Is it possible to UNLOCK just the orphaned process. I know the pid number. Running DS 5.1 on Solaris 8. The UNLOCK command is not automatically available in projects. It is only available in the UV account...

Another possibility would be to extend DataStage with a user-written plugin. This requires some knowlege of C and of course, Progress (and whatever APIs they make available for retreiving data), but if those skill sets exist, a locally custom plugin can be written that would appear on the palette an...

Whe I try UNLOCK ALL, I get the message : Verb "UNLOCK" is not in your VOC. Is it possible to UNLOCK just the orphaned process. I know the pid number. Running DS 5.1 on Solaris 8. -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Tuesday, 19 February 2002 9:14 AM To:...

All, In my job , I have 2 transformer stages. In the first transformer stage, I have used an OCI stage with 4 links , setting the Enable Transaction Grouping option, which commits for each row. For each link I set CONTINUE on Skip and Rollback on Fail. The fifth link from the first transformer input...

Himanshu Patel suggested, among other things, "Try skipping that piece by checking off the OMIT check box." The Omit check box is only suitable for connections to DataStage on Windows NT/2000 platforms. If Omit is clear, the transport used by the DataStage clients to connect to the DataStage server ...

This functionality was removed it is recommended that those jobs that use hash files be modified so these files are created automatically. Since DataStage does a nice job of creating these files on the fly.