DSXchange

Hi,
Prety simple one for all of you..........

If the sequence of job abort in some middle stage of the sequencer.Wat setting need to be done to restart the job from that point only after rectifying the error.

Thanks
Jayant

Yaa its possible you need to have a shell Script which read a file which have all your job parameter values.
Now call this shell script from the before job subroutine promt to get the values.

Hope you r getting me....!!!!!!!!!!!!

Hi,
Can anyone provide me information on how to read a Cofig File .Some link or some material on that.Plus i would like to know more on the following Configuration: processing nodes, node pools, resources, resource pools

hii,
You can do it on the Unix prompt throgh a shell script..............
You will have a file which will contain all the parameters in the same order as the job..
In the Before job Subroutine you can call this file to assign the values to the parameter.

Loading to Db2 API Stage.
I am getting warning in thew transfor stage saying:
Error in Assignment.

Can anyone tell me.
Wat kind of error this is.....??

Hi, I am generating unique key in transformer on the basis of @NUMPARTITION and @PARTITIONNUM . Though it is generating unique keys but the order is random.Cause more columns are passing throgh 1 node.Its a 5 node file. I have tried RoundRobin partition also. Nothing happening!!!!!!! I want to gener...

thanks a lot

HII,
A SIMPLE ONE
When I do sort on the link the osh reads:

tsort -key ARR_ID_AUDIT -cs -asc -key OBAL_WORK_OF_DT -cs -asc -key OBAL_SYS_ID -cs -asc -key OBAL_BAL_CD -cs -asc -nonStable.


what does this -cs means.
I am unable to understand.
thanks
Jayant

Hii all,
I have a column which has date value [SAMPLE(1900-01-01)] in a character (10) field.I have to find the max date out of this column.Max function is not working. Can you help me on this

thanks
Jayant

I am viewing the correct file. The data I view is "^L?" for a field "23.4". .Delimiters are also in place to view it as a CSV. I have tried the String to Decimal format.Can you give the complete format to be written. Wat is the function used in a modify Stage?? Thanks for respons...

Hii, I have 3 decimal fields and all other are char fields.When i view it in unix it give garbage in all decimal field and other char fields are fine.When I view the file in Datastage Sequential File Stage I view all the records properly.I think the problem is in Decimal fields,So i put the Decimalt...

Hi,

Are you changing the name of the Sort key Column and then using it for Aggregation?
You might get this warning if the Sort and Aggregating keys are different or are not in same order.

Thanks
regards
Jayant

Hii Kumar, Wat I concluded from your situation is that.......... You need to put a constraint and find which record is a copy, or which need to be edited, or dropped. You can check key column it and assign a stage variable as 1 if the record is new. If key matches club all non key columns and then c...

I have donr that too........
But it is of no use ...........
I msde a new wrapper but the same problem exist.........

hii, I am generating a simple wrapper to sort two files and give output on a single file.I am generating the wrapper.Noting happens.But it doesn't pop up any window stating successful generation of wrapper or the error. But when i implement it in the job. It throws a error main_program: Could not lo...