DSXchange

Mike is right, but sometimes we receive files with special characters which have to be rejected.
I sometimes use jobs with no limits (only during the running time) with a reject file to store the warnings, so I can run the job and treat the rejects later.

Pierre.

I think the code generated by DataStage is read-only...

Pierre.

You can use a job control to launch your jobs, using the following :

...
NumberWarnings=50
NbWarnings = DSSetJobLimit(JobHandle, DSJ.LIMITWARN, NumberWarnings)
ErrExec = DSRunJob(JobHandle, DSJ.RUNNORMAL)
...

to parameter the abort of jobs after warnings.

Pierre.

You can write a batch file that creates a list of categories and jobs using the following command : dssh SELECT NAME FMT'80L', CATEGORY FMT'80L' FROM DS_JOBS WHERE CATEGORY LIKE '<YourCategory>' ORDER BY CATEGORY, NAME; > FileCat.txt All you have to do after that is to read this file and export jobs...

Thanks for reply, ArndW, Yes, curiously, it accepts all terms in english, except days. I must enter the following sentence : AT 19:30 /EVERY:L,Ma,Me,J,V vmdsr_sched.exe D:\Ascential\DataStage\Projects\REC_Ordonnancement JobMaster_ALGAllMaster 0/50/1/0/0 21 It's not a DS problem, so I'm gonna mark th...

Thanks for reply, ArndW, Yes, curiously, it accepts all terms in english, except days. I must enter the following sentence : AT 19:30 /EVERY:L,Ma,Me,J,V vmdsr_sched.exe D:\Ascential\DataStage\Projects\REC_Ordonnancement JobMaster_ALGAllMaster 0/50/1/0/0 21 It's not a DS problem, so I'm gonna mark th...

Maybe your logs are auto-purged after 1 job run ?

-wave -0 gives you the result of the last run.

Pierre.

(I was joking)... next time, I'll try to be more explicit.

Pierre.

Yes,

My variable names are "in french" because I am "in France".
I did not translate them, I'm sorry.
But you can find good dictionnaries to do that on the web.

Mais, bonjour de Paris.

Pierre.

Hello, I wrote a batch file that does it : !DirDSBin!dssh COMO ON !FicSortie! !DirDSBin!dssh SELECT !CommandeDS! move !FicSortie! %DirSauve%\!FicSortie! set FicResultat=Repository_!Projet!.csv for /F "skip=3" %%B in (%DirSauve%\!FicSortie!) do ( set LigneLue=%%B if !LigneLue! neq "SQL...

Yes, the job was still running, but the stage was finished.
Can it be that the input link is complete, but not the output ?

Hi,

While monitoring a job, I saw a stage in Finished state, but with rows still increasing.
What does it mean ?

Thanks.
Pierre.

Hi all,

Using STATUS command in DS Administrator, I find that disk D: is 164% used.
What does it mean ?
Is there a space allocated to DataStage, and if yes can I extend it ?

Thanks.
Pierre.

It seems I was confusing with another command.

Sorry and thanks for reply.

Pierre.

Hi,

What are the usage and syntax of commands LOG.SAVE and LOG.RESTORE ?
Do they "only" save/restore to/from tape ?
Is there a way to save/restore logs to/from disk to disk ?

I searched it in the forum, but didn't found.

Thanks.
Pierre.