DSXchange

yes this topic was resolved...that was a DB2 connectivity problem

Iam trying to write a user defined sql in DB2 stage user define sql :select * from DW001.DLY_TIME_DEP the error when iam trying to view data is as follows ##E TNDB 000209 01:46:10(000) <dw001_dly_time_dep> Unrecognized argument: select * from DW001.DLY_TIME_DEP [argvcheck/argvcheck.C:3832] can any o...

this is a a showstopper......can anyone help?[:)]

My job looks like this... DATASET--->DB2 HOGAN_DDA_DLY_DMND_DEP is my table. error is as follows: HOGAN_DDA_DLY_DMND_DEP,0: Error Idx = 12; DB2 Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not valid. Reason code "106". If a host varia...

when i am trying to view the data from a EBCDIC file ,it is showing the error as
"short read on import"

10 X-NW-DDA-STMT-FORM-MEDIA-R REDEFINES CC426687
X-NW-DDA-STMT-FORM-MEDIA. CC426687
15 X-NW-STMT-OPTION-CURR PIC X. CC426687
15 X-NW-STMT-OPTION-FUTURE PIC X. CC426687



the letters in bold should be removed

got the answer
thanx for the reply

10 X-NW-DDA-STMT-FORM-MEDIA-R REDEFINES CC426687
X-NW-DDA-STMT-FORM-MEDIA. CC426687
15 X-NW-STMT-OPTION-CURR PIC X. CC426687
15 X-NW-STMT-OPTION-FUTURE PIC X. CC426687

when Iam trying to import metadata from a cobol copy book,it is showing error as follows Error 1 (line 138) 'CC4' column being redefined is not found I have threee columns named "CC426687" in my cobol copy book. " 10 X-NW-DDA-STMT-FORM-MEDIA-R REDEFINES CC426687 10 X-NW-DDA-STMT-FORM...

ray.wurlod wrote:By leveraging more than 20 years' experience with the database, usually in exchange for a professional fee.

I didnt understand ur concept[:(]

What is repository tuning in Datastage?
how do you do that?

how about increasing the size of APT_BUFFER_MEMORY and APT_MAX_MEMORY?

how about increasing the size of APT_BUFFER_MEMORY and APT_MAX_MEMORY?

It is difficult to use a dataset across projects..