DSXchange

Hi We're trying to execute a db2 command from within a sript while calling via the Before Subroutine ExecSh This is the error thats being trapped as a result of which the job aborts exec(): 0509-036 Cannot load program db2 because of the following errors: 0509-022 Cannot load module /usr/opt/db2_08_...

One option could be process the source file in the job control Count the number of lines<excluding the first and last> and compare this with the count field of the trailer record. If they dont- call jobAbort. There are also inbuilt routines that count the number of lines in datastage 7.5 which u cu...

One option could be process the source file in the job control Count the number of lines<excluding the first and last> and compare this with the count field of the trailer record. If they dont- call jobAbort. There are also inbuilt routines that count the number of lines in datastage 7.5 which u cud...

Check also in Task Manager. If dsservice.exe is genuinely not running, I dispute your assertion that "I can still connect to the server (which is on my local machine) and run the jobs." I have stopped DataStage services on my machine (server on local Windows), and I can neither connect fr...

Hi

It says stopped on the Services applet too!

DataStage Engine Resource Service Servive Stopped?

hi

Thnx for that

However my confusion stems from the fact that even though I end the following process(Datastage Engine resource Service - dsservice.exe) I can still connect to the server(which is on my local machine) and run the jobs.

The dsprcd however behaves according to my understanding.

Hi There is a pdf file by the name of ENU-XMLPack.pdf that spells out how the XML stages are used(XMLPACK_20_Designer.pdf for the XML Pack stages). For the task at hand try using a Folder stage -> transformer/xml transformer -> Sequential File Also import the metadata definition thru the manager->im...

Hi, I have a confusion regarding the following the Datastage processes...that are visible thru the datastage Icon in the control panel and the task manager(Windows XP) What is their significance ... Datastage Engine resource Service -> tl_dsservice.exe Datastage Telnet Service -> dsservice.exe Thnx

Thnx

Was making a stupid typo error

Hi I have been able to reset the value using the "ExecuteTCl" at the Before Stage Subroutine. However while trying the EXECUTE command using BASIC code in the Job Control i havent been able to achieve the same. Do i have to Open the SDKSequence file before issuing an EXECUTE command to pef...

Hi

I'm a little confused - Could u please elaborate on the use of Envornment variables witihin a Job.

So U've got to correct ur definitions - have to tried importing the metadata definition in Manager and then importing that.

Check where you are using a correct repeating element...the problem is with the definition.

Try writing to a Sequential file first and see if it works - whether ure getting data out.

Most probably you may not have defined the structure of the source XML File appropriately.

Hi If all your jobs are connected in the Job Sequencer and ure running them from there - u wud only have to change the parameter value once for the Main Sequence( for all subsequent job sequences ). Even otherwise if u've created wrapper scripts where u are reading the parameter values from a file i...

Hi rumu

I'm not quite sure whether u've got a correct design without using a sorter...retaining previous values only makes sense when u have grouped similar rows together...if that is not maintained, the storing of previous values wud result in incorrect results.