DSXchange

hi In routine I am taking value of environment variable DSGetParamInfo(DSJ.ME,"$PATH",DSJ.PARAMDES.DEFAULT) Now value of $PATH set in job is $PROJDEF now when I rub the routine and when I try to display value of $PATH then it is showing as $PROJDEF and not actual path and then my job is ge...

This error message will throw if the source data is invalid.

It is already checked when I ran job

Hi, I have job which loads the data into table using terdata bulkload stage. jobs reads from flat file transforms the data and load it into bulkload stage. In report file I have getting following error **** 05:44:09 FDL4831 DECIMAL type - record too short ============================================...

I want to do update only

Hi I am getting following error in multiload report file. USING A(DECIMAL(18,0)), B(DECIMAL(18,0)) UPDATE Table_X SET A = :B WHERE A = :A; **** 10:03:57 UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid. The job has sequential file ( Col A, B). transformer & Teradata multi loa...

Hi, Ray: My query given here is just a sample. Actually I am selecting four fields with same format from different tables. My intention is to run same job with different source query as parameter creating output in same format. I tried giving query in Quotes and also with '\' . I can see that 'dsjob...

Hi All, I have a job with design as follows DB2/UDB Enterprise Select Stmt --> Transformer --> Flat File The input source query to the DB2 stage needs to be passed as a parameter to the job. When I pass this query while running the job in designer/director, the job runs perfectly fine. My job unltim...

Hi I am writing into hashed file...job is getting aborted after running for some time.....( after some thousand record) due to below error...

InterProcess_229.DB2_Trim_Lnk0: ds_ipcput() - timeout waiting for mutex

Anybody has idea why this error is coming

thanks in advance

Hi, I am new to the Datastage. I am accessing teradata through server routine, Routine connects to teradata and then executes the SQL , I am exporting result of SQL to file. Problem is in file there are some junk charecters after result. i am calling routine fro m job select count(*) from EMP is Que...

hI i AM RUNNING TERADTA sql COMMAND THROUGH ds ROUTINES.
BUT THE OUTPUT OF COMMAND SHOWS LOTS OF EXTRA THING APART FROM RESULT..iS THERE IS ANYTHING WHICH WILL SUPRES THE MESSAGES...FROM TERADATA

hi I am calling script A from routine content of Sript A bteq <<EOF> .logon uDFGFD/GFG,hkj; Select Date; .exit EOF Script connects to teradata and execute the query Routine command is Call DSExecute('UNIX',Script A,Output,Error) My Question is will Output will contain Only result of Select Date or c...

HI, We have input file as follows: XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION XXX XXXX...

Hi , Can any one tell me the meaning of !, <-1> & <1> in the following : Cmd = "db2 connect to ": PServer : " user " : USERDB : " using " : DADASS Call DSExecute("UNIX",Cmd,Output,Status) Call DSU.Jobharieadh(REST,Output) !Ans<-1> = Cmd If Status<1> = 0 Th...

Hi,

I want to capture the duplicate rows in my input file into separte file.could any one help me on this.

Thanks
Siva