Hi,
a table in our database is loaded by multiple jobs and are unknown to us as we just acquired the system.
I need to search for a particlar value passed for this parameter and find out the culprit jobs.
Can you please let me know if there is a way to do it?
Thanks
nsm.
Search found 138 matches
- Wed Oct 19, 2011 7:02 pm
- Forum: General
- Topic: search for a value passed to parameter in whole repository
- Replies: 3
- Views: 1943
- Wed Feb 16, 2011 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do we prevent importing "unicode" Extended opt
- Replies: 8
- Views: 6427
- Mon Feb 14, 2011 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How do we prevent importing "unicode" Extended opt
- Replies: 8
- Views: 6427
- Tue Nov 30, 2010 3:58 pm
- Forum: General
- Topic: calling KeyMgtGetNextValueConcurrent from Job Sequence
- Replies: 1
- Views: 1696
calling KeyMgtGetNextValueConcurrent from Job Sequence
Hi, Hi I am trying to call KeyMgtGetNextValueConcurrent from Job Sequence and it throws below error. JSEQ015_Load..JobControl (@GenRunID): Routine DSX.KEYMGTGETNEXTVALUECONCURRENT did not finish OK, return code = '3' Also I want to find out if there any disadvantage in using this routine. One of my ...
- Thu Dec 10, 2009 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL Copy book having COMP/COMP-3 fields
- Replies: 1
- Views: 2154
COBOL Copy book having COMP/COMP-3 fields
Hi All,
I am receiving a mainframe file which has COMP , CHAR,COMP-3 type fields. After Importing the copy book I see the data types as CHAR,BINARY , DECIMAl.
If a field is DECIMAL(5,2) I changed it as CHAR(5) field.
I am not sure how to deal with BINARY fields.
Please suggest.
Thanks
nsm.
I am receiving a mainframe file which has COMP , CHAR,COMP-3 type fields. After Importing the copy book I see the data types as CHAR,BINARY , DECIMAl.
If a field is DECIMAL(5,2) I changed it as CHAR(5) field.
I am not sure how to deal with BINARY fields.
Please suggest.
Thanks
nsm.
- Thu Oct 29, 2009 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Warning: glibc detected while loading DB2 tables
- Replies: 1
- Views: 2690
Getting Warning: glibc detected while loading DB2 tables
Hi All, Below are the warnings I am receiving when trying to load a DB2 Table using DB2 API stage from a Dataset. Please suggest me what can cause the below. Below set of warnings are repeating for Table Insert and Update. Finally job aborts with SIGABRT. Thanks nsm. Type: Warning Event: DB2_TbName,...
- Tue Jun 09, 2009 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue when writing Timestamp with milli seconds to DB2
- Replies: 2
- Views: 1757
Issue when writing Timestamp with milli seconds to DB2
Hi , I tried 2 different methods. 1)ODBC Enterprise: Get the Timestamp with Microseconds use the left 23 characters and then concatenate "000" to end so, it will have 6 second digits.Passing data to ODBC Enterprise as a varchar worked but the issue with ODBC enterprise is I couldn't pass r...
- Fri May 22, 2009 8:29 am
- Forum: IBM QualityStage
- Topic: Quality Stage - Investigate stage output columns
- Replies: 3
- Views: 4098
Quality Stage - Investigate stage output columns
Hi All, I just started working with Quality Stage. I used Investigate Stage with Word Investigate option. Job ran fine but I couldn't understand the output, Tried looking in the document but I didn't find any explanation refering to output columns. qsInvPattern qsInvCount qsInvPercent I can understa...
- Fri May 22, 2009 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Char/Varchar(unicode) type data conv from DB2->Sybase
- Replies: 3
- Views: 2646
- Tue May 12, 2009 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Char/Varchar(unicode) type data conv from DB2->Sybase
- Replies: 3
- Views: 2646
Char/Varchar(unicode) type data conv from DB2->Sybase
HI, I have a job takes char/varchar type data (unicode enabled) from Sybase to DB2 with no issues. When I tried the other way i.e from DB2 to Sybase it is causing issues. I think its putting null after each character. If I disable Unicode on the target (Sybase) system job worked fine. does anybody k...
- Tue Mar 17, 2009 2:16 pm
- Forum: General
- Topic: Reading the correct file
- Replies: 7
- Views: 3212
you can use unix cut command to get the last nuber for all the files in a separate file then sort in the order you want, then take the last line or the first line depends on the way you sort. As a matter of fact you can use the output of this to the fixed prefix and move the file to different locati...
- Tue Mar 17, 2009 1:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: get Current TimeStamp-(MINUS) 1 Day
- Replies: 5
- Views: 7705
- Tue Mar 17, 2009 1:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: get Current TimeStamp-(MINUS) 1 Day
- Replies: 5
- Views: 7705
- Thu Mar 12, 2009 2:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: get Current TimeStamp-(MINUS) 1 Day
- Replies: 5
- Views: 7705
get Current TimeStamp-(MINUS) 1 Day
Hi,
My requirement is to get CurrentTimeStamp-(Minus)1Day.
I am using CurrentTimestampMS() function to give me CurrentTimeStamp with Microseconds.
In server job/Routine its easier to do this with ICONV/OCONV functions, can somebody help me to do this in parallel job?
Thanks
nsm.
My requirement is to get CurrentTimeStamp-(Minus)1Day.
I am using CurrentTimestampMS() function to give me CurrentTimeStamp with Microseconds.
In server job/Routine its easier to do this with ICONV/OCONV functions, can somebody help me to do this in parallel job?
Thanks
nsm.
- Tue Mar 10, 2009 12:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequential file issue while appending to the same file
- Replies: 5
- Views: 2111