DSXchange

hi gurus, i just wanted to make use of this sub-routine, i never faced such scenerio,i want to analyze how this subroutine works. iam specifying in jobcontrol subroutine. what i understood from gurus is that its not possible to specify DSJOBRUN sub- routine for the job which iam working on in the de...

hi gurus, i want to run the job which iam designing. that means can i use this sub-routine and run the job. is that going to happen. what i mean is my design is odbc--->transformer--->odbc. i want to include this subroutine in the jobproperties tab and run the job. plz help me am i going in the righ...

Hi gurus, my job design is odbc--->transformer---->odbc. i want to make use of DSRUNJOB job control subroutine. i went to job properties, click on jobcontrol tab. how should i specify my jobcontrol routine. syntax:VARIABLE=DSRUNJOB(JOBHANDLE,RUNMODE). is this syntax correct, and where should i speci...

hi,
i used sequential file instead of ODBC still getting error.
i didn't toggle my password, since it prompts to enter either encrypted or string type.

plz help me.
cheers;
vijay

HI, yaa when i click view data, it asks to enter password, when i enter password ,its working fine from the source stage. i didn't touch the NLS tab. i can see one thing actually password tiger is of length 5 But it only changes its length to 7 cannot understand,whats going on.but i can see the encr...

hi, i have defined as username string enter user name scott password encrypted enter password tiger odbc connection string enter dsn name ssss now i have called these parameter at joblevel. iam using the same parameters for both source and target. iam defining in my source and target stages as #$odb...

hi gurus, what i mean is i click on view data tab in the source stage, i can view the data, when when i click on create ddl tab in target stage its creating DDL statement too. iam getting this error. TESTING..Transformer_2: |TESTING..ODBC_0: DSD.BCIConnect Failed to map LOGON2. LOGON2: ??, NLS map: ...

Hi, i defined parameters at project level and making use of these parameters at job level. i have defined parameters like ODBC CONNECTION STRING ENTER DSN NAME SSSSS USER NAME ENCRYPTED ENTER USER NAME SCOTT PASSWORD STRING ENTER PASSWORD TIGER iam using these parameters only in the source stage, wh...

Hi gurus, is there any way with datastage, that if we know job name and project name, it displays even the metadata we used,like generate a report which should also include the metadata which we deal with. i have seen various forums posted by gurus, i have also seen operating system command, yaa i m...

Hi Gurus,
Thanks very much.

Once again thanks, iam marking this topic as resolved.

cheers;
vijay

hi Gurus, i searched in the forum, i found that in case of sequencer we can go for check points, in case of jobs we go for system variable @INROWNUMBER. for eg: the job aborted after loading the 3000 records, by specifying @inrownumber>3000, we can start from recordno 3001. am i going in right way, ...

Hi Gurus,
is there any utility which helps from failures.
like we can insert checkpoints b/w sequencer and can restart from that point, what else if we want to restart from record 100 rather than record no 1, is there any feature in datastage which helps in such cases.

plz help me,
cheers;
vijay

hi gurus, thanks very much. One more thing which is the best way to call this function, as you gurus said that its not best idea to call these functions from transformer stage, then normally where does we use this function, i mean which stage we use to call this function, plz help me. plz help me. c...

Hi gurus, odbc--->transformer--->odbc. i want to use DS function in my transformer stage so that it displays all the link information. i used the function in this way, it says the expression is in valid. DSGetLinkInfo(DSJ.ME, DSLink3.JOB). plz help me in validating the expression and where can i get...

Hi,
thanks very much.
i got it when i view the repository i can see that.
i will mark this topic as resolved.
once again thanks


cheers;
vijay