DSXchange

Version Control is used for versoning Datastage jobs and sequence.

That was one of the wonderful FAQ on Archetecture given by Ray.
But do a search you can find exactly what you need.

Almost everything will lead to a Permission.... or library pointing to wrong path...

Search for DSGetLinkInfo. This is alerady dealt in this forum.
Or dsjob -linkinfo...

Make sure the FTP setting are fixed width and not space delimeted.

HI,
You can directly use TIMESTAMP as key word like

SELECT TIMESTAMP FROM RT_LOGnnn or SELECT F3 FROM RT_LOGnnn DICT VOC

to get the timestamp of each id.

ArndW wrote:Kumar - I skipped the administrator client because it is not bound to a single project, but only to a single instance of DataStage server.

I Agree.

Basic Transformer in PX will always create a overload in server, since which forces the parallel editon to run on sequential mode. But what is the functionality you are tyring to achevie through Basic Transformer?

Adminstrator Clinet too :D

Decimal 7,4 is 4 scale and 3 mantisa part. That is total length (Precision) is 7 and out of which 4 digit is alocated to right side of the decimal point.
The space is for the sigh bit.
Hence while mapping 00002 to 002 warning pops out. You need to extrapolate the target datatype.

Also just check whether, the db2 temp directory is pionting to the same. Check in ../sqlib/db2profile or with DBA.

Dont have Datastage access right now, so not sure about datastage aspect. But you can always write a unix script to clip off the first line of each file and concatinate the rest and read it. And use the script in Before job subroutine.

Yes.
Yes.
By making the server to act simultenously, CPU usage is shared among the existing process, which might make the difference when compared to a dedicated server fo a single process.

hi..thanks for the suggestions.. i am aware that i can concatenate the three files and then use.However i want to use some data stage functionality to achieve the same. Ray, in the sequential file stage--filter command-- i put cat <location of file1> <location of file2> <location of file3>. then i ...

Datastage Adminstrator cleint --> Project --> Properties -- > Environment -- >General ---> TMPDIR