DSXchange

Hi,

is there a function similar to bittest in parallel? if yes, then what is it?

Thanks,

you have to define that in the filter option of the sequential file stage.

try this in your filter option of either sequential file or cff.
or

thanks for the reply. Can I use \X00 value in transformer or define \x0000 in the null field value and define the character set as ebcidic in the sequential file stage to populate 4 0's in the hex format?

well, I am not able to find the option where I can define the value as hex in the complex flat file stage. Please help me find that?

thanks for the reply arndw 1. well, I want to set default of low value(0) wherever I have to write null. this would inturn be used in main frames. to load in a database. 2. I have few files for which I am not able to determine how to read the data. the data format is signed packed hex data that I am...

I have below mentioned 2 questions. could some one please be kind enough to help me understand and solve the issue? 1. I am not sure how to populate the 0's as the low values. using the datastage. the field is of type pic x(004). 2. is there a way to find the nls format without actually knowing the ...

Hi I have few questions. Please let me know your thoughts about the below metioned approaches. 1. there would be a source file XXXX which has to be split into 1000 different parts. for each part there is a column key_id which is generated as a sequence number. However the starting value of the seque...

I am more looking into multiple options from which we can decide from what suits best for our needs. Probably a some web link reference will also give me a starting point as I am not able to find the right web site which describes recovery options

I meant reverting the table to the state that it was before the job load started.

Hi , We have implemented scd type 2 functionality using datastage px jobs. However, We would like to automate the recovery of the data when job fails in between the load. Could you please suggest me the different possible methods? and we should be ok even if we have to go beyond ds like using a shel...

yes, you are right. I have declared both the fields as varchar(10). However, to test i have also tried integer for the first field and date for the second field.

I am looking for an answer something similar to the above one. But, he doesnt seem to be confident. can some one confirm it?

Hi,

Could some one please help me arrange the hierarchy of Conductor node, Section leader and player in the image.

Thanks for the help

Hey Chulett and deanwalker first Apologies if you felt i was arguing. My first understanding was they are system defined. anyways, let me try to define them and check. Ill post the result what i get when i am done.