DSXchange

I am using BW load stage to load the data into SAP BI from a dataset stage using the PUSH data load method. Some time the job runs fine and data gets loaded correctly into SAP PSA. But some times the job aborts with a message on SAP side as 'BW Load - Critical Failure, no job name for PULL job'. The...

Please check whether you are passing the correct values(matching parameters of the job sequence) in the Value Expressions to all the parameters(of the job) in your job activity stage. If everything is fine in the job activity stage then there will be no problem to override the default values of par...

Hello Gurus, Any help with overriding the parameter set values in job sequence for the following requirement: I tried it with defining a paramset xyz.state with the default value as 'TX'. When I am running the job seq with override xyz.state = 'CA', but the output still I see the results of TX. I am...

That answer IS yes, the syntax is setname.parametername but, when you use the mouse (Insert Job Parameter), the syntax is managed automatically. ... I tried it with defining a paramset xyz.state with the default value as 'TX'. When I am running the job seq with override xyz.state = 'CA', but the ou...

Create a parameter in the Sequence job for the state and pass it to the PX job's matching parameter in the Job Activity state. ... Thanks Chulett, passing the parameter from seq to job worked. Can I use the same thing in Parameter set and override the value of parameter set from job sequence to PX ...

I have a job Get_cust_count to get the total number of customers in a perticular state-cd from a teradata table. I am using Teradata connector stage, the SQL is: Select count(*) from Cust_Address where State_CD = '#STATE#' I am passing the STATE as job parameter with a default value of 'TX' in the s...

As noted, you need to remove any hidden Field Marks from the returned value before the number will compare properly. Use Convert to strip them from the output. ... chulett, Thanks for the help. I added coversion to strip everything except the first digit, it worked as I expected. As you mentioned t...

Are you sure your empty file is actually empty, i.e. it doesn't have a header record? You'll need to remove any Field Marks in the output of the Execute Command stage before the number will com ... Yes.. My empty file is empty.. I was running the WC - L < 'file name' under unix and it is returning ...

You can use the execute stage or the Variables stage call an external SQL script that retrieves the value directly from the database and the output trigger or the condition stage reads the value returned and decides on which path to take. Or you can write the count to a sequential file and use a Se...

Hello, I have a job-A that does count(*) into a variable cnt from a table and this cnt is written into a dataset. I have two other jobs job-B and job-C, I want to run the job-B if the cnt is 0 otherwise run job-C (i.e., cnt > 0). How to set this up in the job sequence? Is there any way to recoginize...

Hello, I have a job-A that does count(*) into a variable cnt from a table and this cnt is written into a dataset. I have two other jobs job-B and job-C, I want to run the job-B if the cnt is 0 otherwise run job-C (i.e., cnt > 0). How to set this up in the job sequence? Is there any way to recoginize...

Ray, I am looking for the code that has to be typed under triggers tab/ expression field to trigger job1 if there is data in the table and trigger job2 if there is no data. Please let me know the details what has to be given in the expression field of triggers tab.

Thanks.

Hello, I am trying to pass a where clause value to a relational/odbc/teradata connector stage. Exampe: I want to extract data from Address table by passing the state-code and write it to a dataset. I want to pass the state-cd as a job parameter and override every time with a state value (like, MN, I...

Hello, I am trying to run job1 or job2 based on existance of data in a table. For example, if there is data in a table XYZ for selection criteria then run job1, if there is no data in table XYZ then run job2? Can any one please help me with this (with an example, would be a great) in IBM information...