DSXchange

Hi,
When we approached IBM support team for this we came to know PX only supports VR on import and does not support variable record format on export .

Hopefully this will be fixed in DS v9.1.

Hi Frankline, Thanks for your reply. Our OS is AIX. I have read through your FAQ. This is myfirst requirment related with mainframe so I find it difficult to understand. I have tried setting Record type = variable and format = VB in sequential stage . I don't have clue how to indicate the actual rec...

Hi,
Thanks to all.

Now i got rid of the error.
But i have changed the file format to loop as below.

AA,BB,CC
its working with this format not with
AA
BB
CC

Anyway i found a workaround.
Is there any limit of passing values to start loop?

Hi Josh, Thank you very much for redirecting me to the exact one! You were also involved in that discussion. My file is like AA BB CC I need to pass these values to start loop.I have used char(10) as ray suggested.But iam getting DSSetParam(CLIENT),code=-4 error.I know its related to new line charac...

Hi Josh,
I found that!

Thanks! :D

But is there a way we can pass input field to those variables.or list of values in that?

Hi Thanks, our is like we have input file where we are maintaining the client code. That code is passed as where condition in few jobs based on the client code o/p file is produced for that particular code. We can generalise the process by using parameter in where condition like where client code = ...

Hi, Thanks for your reply. My id is now added to the group.But iam facing issue when running jobs. One job is running fine by both my id and admin id.But other job is not running when i tried to run using myid but its working fine with admin id. Its just simple seq to seq file job. What might be the...

Hi, We have migrated few projects from sol8 to sol10. All the projects are working fine if run the jobs as dsadm admin user. But if we tried to login as individual user the jobs are showing the running mode.not able to stop the job in director.We need to kill the job in unix. As soon as we start run...

Hi Friends,
Thanks for all your suggestions.

Actually the problem is with the directory(folder).It got corrupted due to some reason on unix dev box(dont know why:roll: ).

so we created a newfolder previous one renamed and its working fine now.

Thanks!! :D

Erro is:
"DSD.UVOpen Unable to open folder /xxx/...../xxx"

FYI
The same job is running fine when i tried to mv the input file to some other folder..
is that a permission issue??

Hi Folks, :D We have a job which is taking xml input and giving .txt output. The job desing is like folder--->xmlinput--->xfm--->fileoutput we have defined parameters for file path for that job.When we tried to run the job its giving following error unable to open the path :( We have checked the pat...

HI :D ,
Thanks for all your support.
I tried Anupams routine and its working fine.

Thanks Anupam.

HI ArndW,
The a3 is not always going to have 3 or 2.its just an example.
It may contain any no.

Thanks

Hi Anupam,
Thanks for your solution,let me try and get back to you.

HI ArndW,
Thanks for your response.
Im perplexed

It will be great if you explain me in elaborate manner.

HI FOLKS, :D We are working in DS7.5.1 on Unix. We have requirement as below. Example:source Table A contains a1 a2 a3 MQ2www deployed 3 MQ2xxx Inactive 2 where a1,a2,a3 are field names TARGET: We have to populate the target table as follows If a3 = 3 then we have to insert the target table repeatin...