DSXchange

When i check the Bulkload output Message File. I found below error. Is this error message belongs to datastage or DB2. =============================== SQL3213I The indexing mode is "REBUILD". SQL2044N An error occurred while accessing a message queue. Reason code: "2". SQL2044N A...

Arndw

Sure, i will work with my DBA. Disc space as well.

Hi I am using DB2 Connector as Target Stage. Write Mode: Bulk Load. Table action: Append Record count: 2000 Auto commit mode: off Array size: 2000 Load timeout: 90 Directory for named pipe(unixonly): /tmp Copy loaded data: Use device or directory Loaded data copy location: /dev/null ================...

Arnd

Initially i tried with varchar, later i tried with integer. still i am getting the same error.

this is the first time i am using Rank function returned value as part of user defined query.

-----------------------------------
can you correct me if i made any mistake as part of query.

Hi I am using DB2 Connectore stage as source and target as sequential file stage. My source database is DB2 UDB 9.7, i wrote a user defined query using Rank Function, the result of the Rank capture in to a alias column. I am using the alias column in my Select column list. My problem is when i try t...

Hi Craig My problem is when i read the data from dataset and write into DB2 Book Mark table i am getting this error and abort the datastage job. I am not getting any single quote or double quote data. Book mark has two columns. one is sequence no ( integer ), keygenerate ( varchar 1024). Thanks SReddy

Hi I am getting this working and aborted the job. I created a Book Mark table as part of IBM Infosphere CDC . I capture the Book Mark data in to dataset, in my next job read the dataset and write in to Book_Table using DB2 Connector stage ( write method is Update then Insert ). I saw some one use th...

Thanks

I resolved myself.

Hi

One of my Sequence job was aborted and getting below error.
Please guide me with useful information.

SEQ_Test_Job..JobControl (@Waitforfile_Test): Controller problem: Unhandled failure (-14) encountered calling routine DSWaitForFile

Thanks
SReddy

I try to getting the logs from datastage directory. When the job Abort or Warning.
Advise me how to right the routines.

First time i am working on Server Routine.

Thanks
SReddy

When i try to use the routine posted here I am getting -1.

How you can get logs. Please explain me in reply mail.

Hi

I am reading a EBCDIC file one of the column has COMP-3. When i view the data. some of the data is in good format. But most of data is moving to next columns.

i have some special characters in the begining of the columns. Please guide me to resolve the problem.

Thanks
SReddy

Thank you Hulett & Ray.

Hi

When i am running PeopleSoft EPM 9.1 Sequence job, It is aborted and getting this error.

Controller problem: Error calling DSSetParam(SNAP_DT_SID), code=-4
[ParamValue/Limitvalue is not appropriate]

Please help me with useful information.

Thanks
SReddy

hi

I am working on DataStage EPM Server jobs. One of the job creating two hash file. I can view one hash file , when i view another hash file i am getting below error.

DSD.UVOpen Unable to open file

Please respond with remedy.

Thanks
SReddy