DSXchange

I am facing compilation error for the Datastage job with transformer stage. Below is the error. ##W IIS-DSEE-TOSH-00049 10:11:31(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir ##E IIS-DSEE-TFSR-00019 10:11:31(009) <main_program> Could not check all operators because of ...

I checked the job log and it is the same SQL which is resulting a record when I run in the SQL Developer. And connections are working fine to the source database. Should I change anything to see the same results as SQL?

I have created a server job to fetch records from two different source Oracle connectors and in the next step I am joining those records using Transformer stage. When I execute the source Select SQL queries on their DBs, they result with 1 record each but when I run the server job, they are fetching...

Sorry I just realized that the error was not in the transformer stage but in the source connector stage. I was confused because of the error message. I corrected the source SQL query. Thank you!

okay before that I am seeing this error when I compile the routine:

0002 FUNCTION UpdateUserStatus(Arg1)

^
"FUNCTION" unexpected, Was expecting: Array Name, Variable name,

I have created the routine as mentioned above. And I have created a Server job which selects the columns from two sources using Oracle connector and in the Transformer stage, I am concatenating the columns from two status to a staging variable and updating the UserStatus by calling the routine. Sour...

Thanks for the response! I went through the links provided there. Could you please help me understand the meaning of 'parking the result in the USERSTATUS variable'? Where should I set this variable with the SQL results? Will my server job look something like this? DB connector Stage -> Transformer ...

More information about the scenario:

I have a scenario where I need to pass the results of SQL statements as Parameters to the job. And also those parameters will be used in the next job in the sequence as well. Which is the better way to achieve this?

Could you please elaborate bit more on how to capture the result in use status area and pick up value in the controlling sequence?

PS: I am creating a server job for the first time. You help on this is appreciated!

I have a requirement where I need to compare the Modified Timestamp or Created Timestamp of the input file and If there is a new file, Job needs to be run, if not another flow. Can we use the file properties as source columns in the Datastage job or as job parameters so that I can use Nested Conditi...