DSXchange

It's quite simple at all ...... THE ACTUAL LINE OF CODE : Pin%%V0S2P37.Column%%16 = ( If V0S2.Stagevar%%10 = 1 then (Pin%%V0S2P49.Column%%10 - Pin%%V0S2P49.Column%%7 - Pin%%V0S2P49.Column%%13 + Pin%%V0S2P49.Column%%16) else 0) Pin%%V0S2P37.Column%%17 = ( If V0S2.Stagevar%%10 = 1 then (Pin%%V0S2P49.C...

I found the Basic Code at \\blr11l\AscentialRoot\DataStage\Projects\TEST\RT_BP412, clear text (Basic Coce)

But I can't find the actual place in the code.

But after all, thank you

/Kim

Hello

The error arrives after the message "DSD.StageRun Active stage finishing." - so I don't get a reject in the Transformer stage.

I've got a warning : DataStage Job 412 Phantom 3044 Program "JOB.810341824.DT.1318540820.TRANS1": Line 609, Nonnumeric data when numeric required. Zero used. How can I see the DS Basic Code generated when i compile the job. I would like to find out which field that gives the problem. As fa...

SMF is System Monitoring Facility.
A part of OS/390 that makes system events/time, to use for different kind of accounting.

I don't want to use SAS - I want to use DataStage instead of SAS XMG software.

Today I'm using SAS XMG software to encode the SMF record made by OS/390 System Monitoring Facility.

Anyone know about someone who do it with DataStage, or know a vendor that can supply a plug-in to DataStage ?

You don't connect to an instance, but to a database (DSN).
Catalog the two different databases, and you have the option to choose between the two databases.

Sorry I haven't explained ...

But all the processing I'm waiting for is happening at the DataStage Server. There is no network traffic (GigaBit network) - DataStage only stand there for a couple of minuts until it want to show the table to me.

And it is faster, but I'm not sure that all datatype's is correct with the ODBC interface (but of course that can be checked), and what about accessing the data afterwards.
If I use ODBC for table import, will the access to the table be via ODBC og native DB2 CLI driver.

When I import (Table Definitions -> Plug-in Metadata Definitions -> DSDB2 -> DB2 z/OS datasource) a Table definition, I can see that the process in DB2 z/OS is approx. 10 seconds, but the DataStage Server uses about 300 seconds to process the 8000 tables/view and present it in a window (the DataStag...

Hi Kim (Duke) I want to do it because I have a problem with DataStage Version Control (ActiveX error) - and Ascential Support ask me to uninstall/install the DataStage Client several times. But I accept that the Windows setup.exe don't take any parameters, and I have to do the installation manually....

Is it possible to give any parameters or a responsefile to the DataStage Client setup program - so I don't have to write the license-/authorization information.

I want to do an unattended DataStage installation.

/Kim

Thank you - I'll do it in another way.
/Kim

I do a bad job in explaining what I want to do -sorry. The routine I call as a "before routine" generates a file with 10 records, and I want to use it as input to my job. I know that I can do it in a DOS bat-script, but for now I have done it as a DataStage Basic routine. And my problem is...

I try to set it up as before routine in Job Properties, and only have the ExecDOS, ExecTCL options to choose between.
What should I use to execute a DataStage Routine as a "before routine" ?