DSXchange

I have a job where i use a roune that attaches the job and uses DSGetLinkInfo function to get the link statistics of all links in the ETL job. The routine works well with all links in the job howewer when the link is an input to the container i get an error Unknown link -9. Is there a way in which i...

I have a job where i need to read the log file from DS and write it to a text file. Is there a way in the Universe SQL that i can fetch only the first 1000 rows from the RT_LOGxxx file. Currently i have a counter in a transformer and do not write to the text file when the counter reaches 1000. This ...

I have a sequencer that calls multiple jobs under it. When I launch the sequencer using a shell script I pass it the Warning limit of 50. However this limit is not charring forward to the underling ETL jobs. Is there a way in which we can pass down the warning limits to the job level when launching ...

Same Message. Looks like it is not substituting the query in the file under user defined section because it says Executing SQL statement '/home/acrwrb2/test.sql' and is not executing the actual SQL. ========================================== Executing SQL statement '/home/acrwrb2/test.sql' Error exe...

SELECT DISTINCT 'X' FROM sysibm.sysindexes;

for testing purpose i have a simple sql in the .sql file. This sql executes on the command prompt

Still does not work. Does the .SQL file have to be in a specific format ?? ========================================== Executing SQL statement '/home/acrwrb2/test.sql' Error executing statement '/home/acrwrb2/test.sql'. See following database message for details. [IBM][CLI Driver][DB2/AIX64] SQL0104N...

I have an ETL job where i need to use a SQL file in the User Defined SQL section of a DRS Stage for a DB2 Database. In the DRS Stage Under the General Tab -> Query Type -> User-Defined SQL query file is selected and i give the SQL file path under User-Defined section in the SQL tab. {File}/home/acrw...

Got it, Passed DSJobInvocationId to the routine argument instead of #DSJobInvocationId# and it works.

In Sequencer S1 before i call jobs J1, J2 and J3 i have a routine that i use to lookup the parameters from a file for jobs J1, J2 and J3. In my Job parameters i use <<Routine Name>>.$ReturnValue to get the value of the param returned from the routine. I need the Instance number as an argument for th...

I have a multiple instance Sequencer S1 that has 3 jobs J1, J2 and J3 in it. How do i pass the invocation Id that was used when launching the S1 as a Parameter to jobs J1, J2 and J3.

Thanks

In DS 7.1 server edition I am trying to split an input row into multyple rows. The data in the row tha needs to be split is delimited by ; To do this i use Convert(";", @VM, FIELD2) In a transformer and load it into a hash file as a non key column. When i read the same hash file on the out...

I am trying to sequence the below jobs. Job1a Job2a Job3a Job1---Ok--->Job2---Ok--->Job3 I want to start Job1a as soon as Job1 starts, Job2a as soon as Job2 starts and Job3a as soon as job3 starts. To do this i created custom triggers on Job1, Job2, Job3 Job1.$JobStatus = DSJS.RUNNING Job2.$JobStatu...

I have a sequencer which runs 3 jobs Seq A- Job1--OK-->Job2--OK-->job3 On the sequencer properties i have checked both options Add Checkpoints and Automatically handle activities that fail Now when job 2 aborts the sequencer goes into a status of Abort/Restartable. When i rerun the sequencer using D...