DSXchange

Hi Deepa, Welcome! There is way to achieve what you are trying to do without using either either the aggregator stage or the user defined sql. In your database stage, go to the 'Output' tab. Choose 'Generated SQL Query' for the Query Type drop down. Then in the 'Columns' tab place the MAX dervation ...

In what order did you install the DB2 Client drivers and Datastage Server on the box? I had a similar problem with Oracle8i while trying to import plugin metadata definitions. I had installed the Oracle8i client after I had installed Datastage. After re-installed the Datastage server the installatio...

Out of interest I ran that code in a routine and the answer returned was: 61243.812

We are running DS 5.2 on a Windows server.

Is there an EXACTNUMERIC type parameter in the Windows version or is that an AIX specific operating system variable?

You should be using the exact same credentials as you've used for SQL Plus.

Make sure you're using the correct 'Plug-in Metadata Definitions' in the Manager ie. Ora8i for Oracle8i, Ora9i for Oracle9i etc.

Use different Oconv conversion codes to format to other desired formats.

Install the Oracle Client on the Datastage server.

Make sure your "tnsnames.ora" file on the Datastage server has the entry for the Oracle Database on the Oracle DB Server.

Remove the last stage of your job (job1) and save the input rows for that stage into a temporary staging file (either a sequential file or hashed file). Output the parameter you want to catch into a Sequential file or Database table. Create another job (job2) that uses the temporary staging file as ...

tada!

Simple and effective.

In a Transformer stage create an extra output link leading to a sequential file stage, call it 'Rejects'. On your "good" output link have an expression/routine that only allows alphanumeric characters through (for example writing a routine that reads each character and checks it's ASCII va...

, 1. double to decimal 2. double to char 1. You will have to write a transform to do this. Use the FMT function to do this. Look it up in the help. 2. You don't need to do this in Datastage. Everything in Datastage is a 'string' so you will not need a function to do this. What did you want to accom...

Does anybody have a compiled version of DS.UNLOCK for DS 5.x? It was talked about in this forum: <a href="http://www.dsxchange.com/viewtopic.php?t=85570"> Click Here</a> http://www.dsxchange.com/viewtopic.php?t=85570 This would be a great tool as we do not have ROOT access to our server. T...

Oops! No I'm not. Not using PX. Sorry about that.

Thanks Siva. That was a good idea. Now my job names are far more readable. This also works for link names!

Too bad the Alt+255 character doesn't work for routine names too.

Finally the abililty to use underscores! Hallelujah!

Does this apply to link names? Hashed files? etc.

It makes for my easier reading of names, that's for sure.

How are you building the query for this transaction in DataStage?

Are you using the 'Fully Generated Query' option in the 'SQL' tab of your Oracle stage?

This way it might fill in the 'Derivation' field in the 'Columns' tab.

Blank out the derivation. That should fix it.