DSXchange

You can do something like --- 1. Build a Routine say, ValidateDate(Arg1) using Iconv and Status functions (you will get their syntax in the documentation). In the Routine call Iconv with the Argument as the input date and then call Status fucntion. 2. In Transformer where you are loading the Target ...

DataStage version : Server Edn. 7 Database : Oracle 9i Hi, I am facing problem with import of TIMESTAMP fields from Oracle 9i database using DS jobs built in DataStage version : Server Edn. 7. The job design had to be modified and I needed to import the TIMESTAMP columns in VARCHAR format in Source ...

Hi, Please explain what does the "Array size' and "Transaction size" fields used for in case of Orcale OCI stage used as the Target stage. What does the values assigned to them signify and change the job run properties? I would also like to know whether the "Transaction size"...

That's fine...
Thanks for the confirmation!!!

Hi, I have been currently working on DataStage Server Edition 7.5.2 in UNIX environment. I had come across 2 particular processing stages known as "Row Merger" and "Row Splitter". These stages are available under Processing Stages only in DataStage Server Edition 7.5.2 and NOT in...

According to a certain PDF document that comes with this plug, it says, "The Command Stage is an active stage that can execute various external commands, including DataStage engine commands, programs, and DataStage jobs from anywhere in the DataStage data flow. You can execute any command, incl...

Hi, I am currently working on DataStage Server Edition 7.5.2 in UNIX environment. I have recently come across an information about a particular processing stage known as "Command Stage". This stage is available under Processing Stages only in DataStage Server Edition 7.5x2 and NOT in versi...

Hi, I am currently working on DataStage Server Edition 7.5.2 in UNIX environment. I have recently come across an information about a particular processing stage known as "Command Stage". This stage is available under Processing Stages only in DataStage Server Edition 7.5x2 and NOT in versi...

DataStage Edn. 7.5x2
OS : Windows 2003 Server

Hi,
Could anyone please elaborate what is the purpose off setting custom values to the 2 environmental variables-
$APT_RECORD_COUNT
$OSH_PRINT_SCHEMAS

And how does these affect the Job Log in the DataStage Director?

Regards,
Ratul.

You are correct.
I had mistakenly selected the version as Server Edn 7.5x2 on UNIX.
Actually it is a Parallel Edition running on Windows 2003 server and version is 7.5x2.
I have corrected it.

Thanks,
Ratul.
----------------------------------------------

DataStage Server Edn. 7.5.x2 OS : UNIX Hi, I have 2 questions regarding the usage of parameters in the ExecCommand tab of the Execute Command Activity stage of a Job sequence. Suppose Job Stages names are "JobStageName1", "JobStageName2", "JobStageName3". 1.Through the ...

DataStage Edn. 7.5x2
OS : Windows 2003 Server

Hi,
Could anyone please elaborate what is the purpose off setting custom values to the 2 environmental variables-
$APT_RECORD_COUNT
$OSH_PRINT_SCHEMAS

And how does these affect the Job Log in the DataStage Director?

Regards,
Ratul.

DataStage Version : Server Edn. 7.5.2 OS Platform : UNIX I was facing a problem when trying to open a Job; a popup comes up with message "Job <jobname> is being accessed by another user". I had then enabled the option "Enable administration in Director" in project level through A...

Datastage version : Server Edn. 7.5.2 OS Platform : UNIX I was working this particular job named say, 'BuildBillHist'. Due to some problem with my machine, I had to hard boot it thus losing all unsaved informations and also without being able to close the Designer. Next time when I restarted my mach...

Hi kduke,

Can you please refer the website name where you have actually posted this code. This would be much helpful. Also if possible, do send me the code in mail/private message.