DSXchange

hi..
i want to know the DS admin command to list out how many HASH files are there in VOC with NAME.

so i can make list.

if some one has some sample job. then please send me mail

thanx.

u can do this same way as tony answer quesion of Sonshe... u need to pass this seq file and do the lookup...and pass the data to same hash file. in the transformer.... you can easily give the condition with lookup... like stagevar=If isNull(Lookup.Fd1) then '' else Lookup.Fd1 in Tranforrmer stagevar...

hi..all.. nice talks.. i am very new to this Forum and datastage.... just started when peoplesoft started the EPM development with datastage.. i like ascential..and want to go in depth as much i can go.. but documentation is not..so interesring .. there are no good examples..given.. i think i will b...

ok.. the syntax is depend upon the Database,,, but my question is whther all the above sys variables related to date..will be provided by... ascential..? bcoz the job i am creating is goin to run on Oracle,DB2,OS/390 and MS-SQL server databases... so syntax in DRS stage i am not going to change.. so...

hi.. all. i want to know where i can get help of getting list of different system variables like %CurrentDateIn,%DateTimeIn(?) ,%DateTimeOut.. this are the variables..i am firign in DRS with User defined SQL query.... but i am not able to get the help topics on this.. please let me knw if some help ...

hi..
guys..
we have more than 100 columns in Source DRS Stage...
in derivation we want to write RTRIM(LTRIM()) for all the CHAR Columns..
this is taking lot of time to write manually..

is there any shortcut method to this.

thanx in advance

hi.. Roy can u tell me what is server side tracing and what are the advantages of that Hi, I think you should start with analizing the machine state when you have this problem. check for memory usage, processes that are running and so on. I think you'll find the problem after this check (might need ...

hi.. all... we have Win 2000 server with 4GB RAM, 400 GB HDD... its kind of High End Server installed with Ascential DataStage 7.1r1 we have some problems..........like server speed is getting reduced after 4-5 hours of work. we are 20 client connecting to server and working on that.. i want to know...

thanx
ray
for for gr8 reply...
can u please tell me the how to learn or know all this admin command..
is there any book or online manual available

hi.. guys i want to some of the adminstrator command for reading and writing the hash files. i know some commands.. like.. e.g suppose my hash file name is HASH_XYZ column name type A (key) Char B int C int now i know select and Insert command to fetch records and write data into them.. but i want t...

there is pdf book available..in datastage online manual for Basic programming....

else for Universe..Query ....i also want some tips on that..

and some thing on..Datastage Administrator Command..

Can any one give me guidance of Ascential Certification..
i want to do that..

but i dont have any idea

But.
Ray
we have Win 2000..as Server
though there is chances of Parallism...
how can i achieve this in Win System..
only using IPC..or there are still some other Methods..

waiting for reply..

hi.. all here we are developing Fact job in that. we have to populate Error Table for each and every lookup.. now the situation is we have 4 different Error Table.. E1,E2,E3,E4... and we have 24 lookups..so..for all the 22 lookups we have to populate the Error Table.. now....in my job ..i m doing 6 ...

hi..
ray..
i like to use...IPC stage..
i think it will increase the performance..
if any other.........method..to increse the performance..
please ..tell me..