DSXchange

yes, of course, but the problem is that de length before 2000 is not always the same.

Thank you for question.
By

ok, but the job status is RUN FAILED , RESET, NOT RUNNING,..?? but not Stopped, Abborted,...
Is always RUN FAILED an Stopped and Abborted status?, I don`t know...

Hi,
I want to reset a job from unix shell, but I want to know before run the statement 'dsjob -run -mode RESET' the job status.
Can Anybody help me?, I want to do something like if 'DsJobStatus'= Stopped or Abborted then dsjob -run -mode RESET, in a unix shell.
Thank you
Angel

Thank you for your very quick replay.
Angel

Hi,
can anybody help me about how can I do to run a datastage job in unix shell?. I want to run it without DataStage.

Thank you,
Angel

Hi, I want to create a file name during run time. There is the DSJobStartDate macro, but probably I not used it correctly. How can I use it?. I am writing this one in the Sequential file stage: File Name: /var/opt/aat/p/sl/shr/carga_fz_SLDIOMQ:'_':DSJobStartDate but the file name result is carga_fz_...

Thank you very much Vincent.

I have a job that does the convertion from a sequential file to a table. The structure of the secuential file is: PRIMARY KEY | BILL NUMBER | TELEPHON NUMBER | DATE 00001 999999 8765443 01/01/2003 The structure of the table is: PRIMARY KEY | BILL NUMBER | TELEPHON NUMBER | DATE 00001 999999 8765443 ...

Hi all, We have a DS server on HP-UX and a DS client on Windows NT 4.0. DS version is 5.2. Between them there is a firewall (Checkpoint 4.0). Everything goes rigth whenever you keep saving your project (with Designer), in such a way that client and server are sending packets each other. However, if ...

Hi,
when I try to open a job, it shows this message:
'Job xxxx is being accessed by another user', I am the only user connected.

Thanks,

Thank you very much for all these replies.
You are all invited to Spain for a beer.[8D]

Hello everyone from Spain, I'm a new DataStage user and I have a question: I have an Oracle table with the following structure and I want to use an 'Aggregator' to gather its data, according to the type of access, in another table. The structure of the first table is: - Application(PK) - User(PK) - ...

Thank you for your reply, and for your spanish too.
Now I am not working with DataStage but will be work in it in June. My previous message was only to know if there are any friend what I can explain in spanish for the future problems with Datastage.
Thanks for all and see you soon.
Angel