DSXchange

Yes Ray,the last message was "Job has been reset".

Thanks
Sue

... the jobs failed for the same reason and we could finish them after re-running those scripts manually.... What was the reason? Are ANY events logged either in DataStage logs or in cron (or script) logs? Ray, In the DS job logs, it says that " Resetting the job". Any ideas? Thanks for y...

Hi, For the last couple of days we are facing a weird situation which we never experienced before. DS jobs are scheduled using cron utility and unix scripts invoke these DS jobs to run at scheduled time. But the unix script after processing initial stages(checking the run file etc;) and at the time ...

Thank You So Much Chulett.

Will let you know once i get my desired result.

Chulett,

I was struggling on using the derivation, but after some tries found it:

Output Columsn SPCT : SPCT1,SPCT2,SPCT3(Derivation Used)

Is there any way to get distinct records in pivot stage itself? Or Do i need to use Sort after pivot?

Please advise.

Sue

Chulett,

I tried 'Help' also but it is more of theoretical rather than practical(that provides with an example).

Thanks

Sue

Also, I could see only one Pivot stage in my Processing group in the designer. I am using DS 7.5.1


Thanks

Sue

Ray,

Thank you for your swift response. I am currently running a test job to do this using pivot stage. But i dont find a pdf in my installation directory:
C:\Program Files\Ascential\DataStage7.5\Docs\

I dont have a installation CD also..

Can you help me providing that pdf?

Thanks
Sue

Hi, We have a table where the layout looks as below: BRANCH JOBNO REGION DISTRIBUTOR SALESMAN1 SALESMANPCT1 SALESMAN2 SALESMANPCT2 SALESMAN3 SALESMANPCT3 We are supposed to fetch the records into a new table with the following layout: BRANCH JOBNO REGION DISTRIBUTOR SALESMAN SALESMANPCT We could fet...

Hi, We have a requirement where we require multiple matching rows from refernce data to be outputed out of a lookup. We are using Datastage Server Jobs. Can someone help us on how this can be achieved through Server Jobs Eg: Master File/table: Id Name 1 A 2 A 3 B 5 C 6 C 7 C 8 C 9 C Refernce File/Ta...

Thank you so much!!

Hi,

We have a requirement in our project where we need to abort a job When the rowcount of the source table is zero.

could you please let us know how to check the table source count in transformer stage and based on that condition aborting a job?

Thanks
Sue

Hi,

I could resolve by changing the stage to 'DRS'.

Thanks
Sue

Hi,

We have a source filed of type' BLOB'. DS is throwing error when i tried to view the data due to the incorrect datatype for that field.

Please give me any ideas of eliminating that error.

Thanks
Sue

Hi, We are unable to export datastage jobs using the 'By Category' Option. When we try to import the jobs Using 'By Individual Component', we are able to import the job. Here is the error we are getting when we use 'By Category' : Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check Dat...