DSXchange

I have a job design like MQ--Transformer--Server Shared Container(with Folder Stage in it). I am reading around 4 messages from MQ at a time and creating each XML for each message and storing in a FOlder stage. each xml is of around 1.2 MB size. I increade the APT_DEFAULT_TRASPORT_BLOCK_SIZE to high...

Thanks Ray, In the job i am producing lot of other Files too. I just wanted one File alone in UTF-16 Format. If i change the setting of NLS in the job properties level to be in UTF-16 then all the other files i am producing would be in UTF-16 format. Is there a way that we can do the change in one s...

Hello

I need to produce the sequentla File in UTF-16 Format. I have only one Field which i am mapping from oracle to Seqfile.
Default Project NLS is defined as ISO-8859-1
Please help me on this

i accomplished it by dividing the rownum with the job parameter and applying ciel function.

Thanks

hello chulett,

This is different logic i have to assign one disticnt number for every 4 rows and there is no identifer to differentiate the change of value from the input stream

Thanks

Hello I have a requirement where i need to read the data from seq file and write it to a seq file. i am using transformer and running the transformer sequentially. I am using a job parameter called group number. If the group number is 4 then i need to create additional column called group number and...

Hello

I am loading self referecing data into table.
i.e i have Col1 and Col2 and couple of other fields. Col2 is a foreign key to the col1 which is PK.

When i try to laod my data is geting rejected because of FK vilation (sqlcode:-2291).

Is there a mechanisam tht this can be done.

Thanks

All the other projects (A,B,C) uses the same id for day today activities. Thanks all for your reply. I got a plan But I not sure whether this come out good or not. Please advise Step 1: Create a user like dsadm. For example let the user name be demadm for project D Step 2: Grant all access to demadm...

I'm using IBM websphere 8.0 And the job is server job

Hi All,

Iam analysing one of the job in that i have seen the value for one column hardcoded as '$1'.

Can someone tell me which value it refers to '$1' if we hardcode in transformer.

Thanks ray ....
And one more question Is it mandatory to give dataset file name with .ds?

Hi all, Can anyone tell me what are files created when we create a Dataset and their locations? And i searched in this forum then i came to know descriptor file and control file will be created for each dataset. Whichfile will be created in Resource disk path? And where will be actual data stored?

Is there any command to run jobs through CLI.

Thanks

Hi all,

I want to copy user Defined variables from one project to another project .I searched in and i found i need to copy DSParams file to another project.

Can anyone tell me that i need to copy DSParams.keep also to that project ?

Thanks ray for the information