DSXchange

Ernie , Excellent description and I appreciate it.

Do we have any enhanced features or RCP support in XML pack/plug-ins , if you buy seperately from IBM ?

Just wondering to know Expert's help, Why XML stage does not have 'Runtime Column Propagatin' property ? I have done many jobs in Parallel without loading the metadata of a job (sequential file , parallel job ) by passing the schema file dynamically while running job. Just wondered to know why can't...

gateleys means is below:


MyString = "ABCDEF"
MySubStr = Right(MyString, 3) ;* answer is "DEF"

APT_COMPILEOPT--->-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c

Its looks like the above is incorrect.

Remove -W/EHa and try.

I agree with "JoshGeorge". I too tested the job with above example, but unable to produce the wrong result. There is no weirdness in my results.

I guess, something due setup or OSH libraries.

Try this :

dsjob -run -param period='june-05' projectname jobname.period

I followed the this approach.

viewtopic.php?t=110457&highlight=pivot

You can also query by using ds command 'dssearch'

I belive( what I understood from docs ) , Pivit only write Rows to Coumns.

[code] Appreciated your help to achieve below: I have data coming in the format : Input ----------- rec_no ctr code 1 3 ABCD DEFG HIJK 2 2 ABCD DEFG Output --------- rec_no ctr code 1 3 ABCD 1 3 DEFG 1 3 HIJK 2 2 ABCD 2 2 DEFG I have to split the record based on the Counter. [/code]

Yes, I know. DSGetStageInfo() does not take a list of stage names as its second argument. I dont think that I am doing so. When look into the code, I have a for loop which gets the stage name from the StageList ,comma seperated output in JobStageList variable by Field satement. * Loop thru all the S...

Thanks Ray, But the subroutine works for PX Job, fails only for Server Job.

The design of both jobs are same:


Server
----------
SeqStage----> Xfm------------------>ORAOCI9


Parallel
----------
SeqStage----> Xfm------------------>PxOracle

$IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF * ------------------- * Open a Sequentila File and write the Info Ans=0 TempDir=TEMPDIR TempFile=LOAD_COUNTS_FILE HdrString='JobStages|JobStageLinkNames|RecCounts' ValidOpen = @FALSE FileName = TempDir:'/':TempFile If FileName Then OPENSEQ...

The reason I am asking for this, I already wrote a routine which scans thru the job to get the OCI or PxOracle Stages ( given a ServerJob, Px Job) and find out all the links for that OCI/PxStage. And find the Link Counts for Input and Reject/OutPut links (i.e LinkTypes of 1 , 3 ). writes in to Seq F...

Hi,

In which Universe table the Job log will be stored ? I want to write a routine to get the seq file with the job logs.

Yes, I can get the job logs via DSGetJobInfo and LinkRowCounts..etc. But I want to get it from Universe Tables.

Appreciated your help.