DSXchange

Im using DSJobReport after job subroutine. Is there anyway where I could write the status to a specific file and only see Job status in it?

Im unable to use in after job subroutine from "Job properties". It has a pre-defined list of functions and wouldn't let me add new function.

can we not have something as in server DSGetJobInfo function in PX?
Is running through a command prompt only option to know about status of a job run in PX?

How to capture job run status in a file in PX?
I want to know if it run sucessfully/aborted ?

I think we need the filehandle, Infotype as -
DSGetJobInfo(DSJ.ME,DSJ.JOBSTATUS)
When job runs successfully value is 0. what are other numbers?

Im moving data from source type CHAR40 To target type CHAR10. When I load the data into SQLSERVER im getting an Warning message - Ref_T63GS02_Load_S_T_US_v6..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE=0 [DataStage][SQL Client]Data h...

If my DS Server job aborts how do I capture the status? I want ideally want to capture the status into a column in transformer stage. Thanks1

Re-posting as there was no answer on this since yesterday. Any solution response would be appreciated. ------- We currently have an architecture where we will be running batch loads based on a RUNDATE on a daily basis. There are three stages that the data batch needs to pass through. Stage 1. Source...

How do we achieve the same key generation functionality in PX?
Im looking for generating keys pointing to a file that would store next val just like the these 2 routines in Server. Thx

There was no urgency seeked as remarked. There was tremendous posts today and din't want the post to be lost from "Recent Topics". May be that was crazy but motivation was diligent.
Would appreciate any suggestion on the architecture. No rush! Thanks!

How do I convert a numeric value to BigInt in Server?
Eg 100.44 to 100.
Thanks

pl. answer

We currently have an architecture where we will be running batch loads based on a RUNDATE on a daily basis. There are three stages that the data batch needs to pass through. Stage 1. Source - Standardization Stage 2. Standardization - Cleansing Stage 3. Cleansing - Target In the first stage we extra...

When I import my table which has column type DATE it wouldn't let me view my data. Error below - ##I IIS-DSEE-TUTL-00031 10:48:03(001) <main_program> The open files limit is 15000; raising to 65536. ##I IIS-DSEE-TOSH-00002 10:48:03(002) <main_program> orchgeneral: loaded ##I IIS-DSEE-TOSH-00002 10:4...

I have a file listed in the Dependencies of Job properties.
Assuming I have a value in the file that I want to use in transformer stage. How do I achieve that?