DSXchange

If you want to do it at datastage level go to director and run it by giving the appropriate parameters it would run as it normally runs only thing would be it will skip the checkpointed onces which ran sucessfully on the prior run.

orchadmin describe also shows the same config file ==> orchadmin describe /data/ds/hbus/dev/etl/datasets/copyAcctArrQc78.ds ##I TFCN 000001 05:57:43(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved...

I am trying to dump a dataset using orchadmin utility, the output is pasted below : ==> orchadmin dump -name /data/ds/hbus/dev/etl/datasets/copyAcctArrQc78.ds ##I TFCN 000001 04:56:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Softwa...

and also i cannot copy and paste the commands in dssh, if i do so the case of characters is toggled.

I have started dssh from telnet every thing is fine untill i run some uv commands where the result each time it asks me to enter any key and then it superimposes the next page (each page has around only 12 lines) over the current one, is there a way where the result canbe viewed without superimposin...

I have a doubt which i would like to clarify, when the job is compiled it creates some files in the project directory, for an user who belongs to the same group what permission on these files does he need to have to run the job (is an excecute enough or write is also required); as per umask 022 it l...

Before converting a varchar to Decimal its a good practise to check if the record contains compatible values that can be converted to decimals ussing the IsValid() function. Datastage converts all non-numerics to all 0's when converting chars to decimals.

I was trying to write onto a hahsfile but the permission were not allowing me to do so, the file was written using "allow stage write cache" and for each record i was getting a warning which was been written to the log file. Since the source had large number of records i stopped the job st...

One possibility is that if I create a job with my user id in Designer and the if i try running the job with another id using this command and if the there is no access for the second id to run the created job this happens. Solution: Use the same id with which this job was created or if you are able ...

[If IsNull(Column A) Then SetNull() Else Column A What are you trying to do here as a straight move would be sufficient as there is no arithmetic expression or function where Column A is being used. Check if you have specified column A as Nullable YES in the metadata and if this is a database stage ...

As all PX job stages eventually land up into osh script how does the transformer stage's life cycle differ? The transformer has to be compiled using C++ compiler and then linked, this would create machine language instructions now how are these converted back to the osh code? Is there any utility th...

"Otherwise, &PH& is a directory within the project on the server. The file will have a name made up of the program name (DSD.RUN or DSD.StageRun for server jobs) followed by the pid, date and time in DataStage internal format.
"
How about parallel jobs?

well i tried the dsrecords -n <dataset> It gave me this error Could not load program dsrecords: Dependent module liborchaix3.a(libtemp.o) could not be loaded. Could not load module liborchaix3.a(libtemp.o). System error: No such file or directory I have sourced the dsenv file and added the path of d...

ArndW wrote:A NULL (0x00) can be stored, as can an SQL NULL (0x80). Both are stored as-is in hashed files.

In that case is char(0x00)=@NULL and char(0x80)=@NULL

And what if the shorter string is greater than the longer string and the end of shorter string is encountered.