DSXchange

How do we implement SQL "NOT IN" logic in Filter stage. I have following condition in a filter stage which does not output the expected number of records. (Field1 <> Val1 Or Field1 <> Val2 Or Field1 <> Val3) and Field2 <= Val4 But If I use the following in the transformer it gives the corr...

Ray
Thanks for the reply. "someone" is a consultant and he is not here anymore and I am going to ignore that advise.

I am designing a job where I need to get all my date keys from the date dimension table. Input data is considerably small so using lookup stage rather than join stage and db2 connector stage to read the table and passing it through a copy stage to multiple links to get all date keys say 14 links. 1....

We just upgraded to 8.7 from 7.5.3 Parallel and we are seeing issue with CFF stage. In 7.5.3 CFF stage we have the DATA FORMAT option in OUTPUT tab with the values of EBCDIC and ASCII where as in 8.7 we only see NLS as the value which is messing up the data. We installed NLS during the installation ...

Found the issue...'Job Name' column is defined as vargraphic data type so the query tool I was using was not able to display it. I converted to char and it works now...

Thanks...

I am not asking for fast response here but just wondering if I explained my question properly...Does anyone else have the issue or is it just on my side ?

Thanks for your time...

SELECT R.JOBID, J.JOBNAME, RUNSTARTTIMESTAMP, RUNENDTIMESTAMP, ELAPSEDRUNSECS, RUNMAJORSTATUS, TOTALROWSCONSUMED, TOTALROWSPRODUCED FROM "DSODB"."JOBEXEC" J, "DSODB"."JOBRUN" R WHERE R.JOBID = J.JOBID AND J.JOBNAME = 'MyJob' When I execute the above SQL, I ge...

We do have Operations console but we would like to have them in a table. Are you familiar with the tables behind the Ooperations console ?

shobhit - That's what I am doing and storing the result in a table.

Ray - We are on 8.7 but we would like to store this data in a table and in addition to that we are also storing cycle date and the table name on this table so that users can query this table to find out how current is the data in a table. I believe operations console gives more detail level job info...

I am trying to collect the Job Status of (say) Job1 like Job start time, end time, run status etc and I built a reusable job (say) Job2 for this purpose. Question is that I want to run the Job2 when Job1 finishes successfully as well as when it fails. What I can do is that, Create another sequence j...

I am wondering if anyone know the table name in xmeta database ? I am aware that there are lot of tables in there and vendor does not want to make is easier wantedly but am wondering if anyone found that information. I am trying to get information such as Job Name, Job start time, Job end time and j...

Hi, I am getting following error trying to check for null in staging variable in transformer in a timestamp field. APT_CombinedOperatorController,1: Fatal Error: Null value on the accessor interfacing to field Code is: If Len(Trim(Output.ROLE_START_DATE_lkp))=0 Or Len(Output.ROLE_START_DATE_lkp)=0 O...

I have an input file which I have passed to the same routine in older version and newer version and both generate different sets of output files with different file sizes. I don't think it will be useful to paste the content of the files as it is still in EBCDIC format not ascii. There is another pr...

We have a routine (wrote in Basic) which works correct in 7.5 but not in 8.7. Are there any changes to the DataStage Basic in the newer version ? This rouutine reads a Master Mainframe EBCDIC file and breaks it into multiple files with base and riders. We are in the process of upgrading from 7.5 Par...