DSXchange

hey
devesh
if u are using DS ver 7.5
you need to check all the parameters in Sequencer are either set to Environment parameter, $PROJDEF or set to default.

i think that is the one error here.
try it out

thanx ray..
for nice expaination..

himanshu

Hi.. All i have questions about the Hash files managements.. i am working on the project where we are processing billions of data through..hash files.. now i have some 8 Hash Files which i am reading through routines....in lots of jobs. among these 8 Hash files....size varies from 1 row to millions ...

Hi..
Ray i try it for Windows..
but ECHO $hd is not working because command is not present..

can u please tellme for windows DS Server.

thanx...for reply

hi.. folks i have searched forum for this keyword ..but not able to get wht i want. here is my questions.. i am storing my hash files in to the directory...different then the default.. now this directory path is stored in to Environ parameter.. so its also not fixed....means it depends upon customer...

hi.. adding to this questions.. we have almost all HASH file stored in C:\projecttemp\ppl directory.. now i want to read this HASH file ...in routine... when i apply 'SELECT SRC_SYS_ID FROM HASH' it gave me error that hash file doesnt exsists.... so how can i do DS Admin Query in Routines on HASH fi...

hi.. i am pretty new and may be one of the youngest in this group.. i am working in company which directly not involved with ascential corporations.. we are developement parterns of ascentical customers.. so let c where ...future goes..... but because i can say more than 50% of members in this forum...

Hi..
i want to install datastage on linux platform and want to learn
Parallel extender.
is it possible.?

hi.. u can create routine..to read all the colums name, length and scale off the Tebledefinations.. try this routine it may help... here in discussion i am not clear wht exactly u want ..bcoz after my first reply yesterday....today ..discussion bcomes..very long.. any way.. try this OPEN "DS_ME...

hi..
in univers you can try this query

SELECT @ID, CATEGORY FROM DS_METADATA WHERE CATEGORY LIKE '%#CategoryName#'

u can use universe stage and generate this query...
u can read table defination through this..

himanshu

hi.. i am just passed out my engineering and joined one IT firm recently last 10months before. in INDIA. we are working for peoplesoft New product release. EPM 8.9. so luckly i got chance to work on this project from india. with these Forum i learned ..lots of things about datastage..and how it work...

hi..
you can take export of all the 500 jobs..as XML format.
open in to TextPad Editor where u can play with XML.
then use Find/Replace. and change all 23 to 19.

hi.. all how can i Modifiy Category structure without Moving Jobs. here i have structure like E.G. A-->B->C-->D-->JOBS NOW if i want to change a name of A to Apple B to Boy and C to CAT.. without moving all the jobs in JOBS category. how can i do it. because this is timeconsuming process. so i want ...

hi..
i want to know which job is using aggregator stage in entire 500+ job
project..
can any one tell me that how can i do query on DS Admin...
or any other method which reduce my time..to search this..

thanx in adcance///

hi..
all
i have to rename some 200+ jobs..
can any one know any shortcut method.

thanx in advance..but this is very urgent for me.

him