Thanks for the information Chullet....chulett wrote:How well have you managed your table metadata? From the Manager, find the table definition in question and use the Usage Analysis tool to see all jobs where it was used. The icon looks like a g ...
Search found 79 matches
- Wed Feb 24, 2010 11:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using table name how to search the related Jobs
- Replies: 2
- Views: 3262
- Wed Feb 24, 2010 8:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using table name how to search the related Jobs
- Replies: 2
- Views: 3262
Using table name how to search the related Jobs
Hi,
I am looking for any option is available at the Datastage where I can search the Job names where particulor table has used in those Jobs?
Is any utility or option is availble?If so can pls share u r thoughts?
Thanks
Raj
I am looking for any option is available at the Datastage where I can search the Job names where particulor table has used in those Jobs?
Is any utility or option is availble?If so can pls share u r thoughts?
Thanks
Raj
- Tue Aug 25, 2009 12:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ASCII Data -Cobal Copy book
- Replies: 4
- Views: 4421
Is it possible to share the copybook
Is it possible to share the copybookSainath.Srinivasan wrote:Are all records of same format ?
- Tue Aug 25, 2009 12:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ASCII Data -Cobal Copy book
- Replies: 4
- Views: 4421
Is it possible to share the copybook
Sainath.Srinivasan wrote:Are all records of same format ?
- Sun May 31, 2009 11:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Operator Error
- Replies: 1
- Views: 3853
Operator Error
Hi I am using Sap pack R/3 bapi stage.
Getting the following fatala error
PACK_for_SAP_R_3___BAPI_6,0: Failure during execution of operator logic. [api/operator_rep.C:399]
The same job is getting executed without any issues at server job.
Can any one explain what could be the error.
Regds
Getting the following fatala error
PACK_for_SAP_R_3___BAPI_6,0: Failure during execution of operator logic. [api/operator_rep.C:399]
The same job is getting executed without any issues at server job.
Can any one explain what could be the error.
Regds
- Wed May 20, 2009 2:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IDOC interface functional module
- Replies: 0
- Views: 2419
IDOC interface functional module
Hi,
I need to use the IDOC interface functional module EDI_AGREE_PARTNER_INSERT at my DS Job.
Any sugetions on how I can call this FM?
I know that we can call a BAPI functional module using BAPI Stage.
Can any of you focus some light on using the IDOC Interface functional module at the DS?
I need to use the IDOC interface functional module EDI_AGREE_PARTNER_INSERT at my DS Job.
Any sugetions on how I can call this FM?
I know that we can call a BAPI functional module using BAPI Stage.
Can any of you focus some light on using the IDOC Interface functional module at the DS?
- Tue Jun 24, 2008 1:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Loading into Packed Decimal Field
- Replies: 1
- Views: 2427
Loading into Packed Decimal Field
Hi, I have a scenario where I need to Load 7 character length value into PIC S9(5) COMP-3 datatype filed, As per the datatype it is accepting only 5 characters from the source to target. If I tried to populate more than 5 characters the target field is filled with zeros. Is any possible way to achei...
- Wed Dec 12, 2007 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Stage Insert Update and Delete
- Replies: 3
- Views: 5368
Oracle Stage Insert Update and Delete
Hi, In one of the Job we are loading the source records into oracle table based on the following constraints. If flag value is A Then that record needs to be inserted If flag value is D Then that record needs to be deleted from the target If flag value is U Then that record needs to be updated at th...
- Tue Dec 11, 2007 2:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC TO EBCIDIC
- Replies: 8
- Views: 5630
Hi Rajasekhar, The test data should be coming from source. For Example : If your source Cobol flat file is coming from Mainframe you need to get the file from Mainframe as input source via ftp plugin or CFF stage. This is best way of testing rather than creating a file manually to avoid any incompa...
- Thu Dec 06, 2007 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC TO EBCIDIC
- Replies: 8
- Views: 5630
Re: Thanks
If the record schema is simple, the Sequential File stage also has the ability to "read as EBCDIC" or "write as EBCDIC". Ray & Aruna Thanks for the inputs. As of now we about to moved to Build phase. As soon as I do some experiment with Cobol files . Probably i'll come up wi...
- Thu Nov 29, 2007 11:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC TO EBCIDIC
- Replies: 8
- Views: 5630
Thanks
If the record schema is simple, the Sequential File stage also has the ability to "read as EBCDIC" or "write as EBCDIC". Ray & Aruna Thanks for the inputs. As of now we about to moved to Build phase. As soon as I do some experiment with Cobol files . Probably i'll come up wi...
- Thu Nov 29, 2007 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC TO EBCIDIC
- Replies: 8
- Views: 5630
- Mon Nov 26, 2007 11:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC TO EBCIDIC
- Replies: 8
- Views: 5630
EBCDIC TO EBCIDIC
As a part of Extract and Loading we have two type of loading 1. source is EBCDIC AND TARGET IS ALSO EBCDIC 2.source is ASCII AND TARGET IS ASCII format. Can any body who has worked on COBOL files and loading on to COBOL FILES can throw some light on the extracting and loading data to and from the EB...
- Fri Nov 09, 2007 5:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding a particulor column in all the Teradata tables
- Replies: 4
- Views: 4254
- Thu Nov 08, 2007 10:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Finding a particulor column in all the Teradata tables
- Replies: 4
- Views: 4254
Finding a particulor column in all the Teradata tables
Hi, We are using the Teradata as Target Database. But in some tables we defined one column CUSTOMER_ID as Decimal now we want to modify as Varchar. But we are not sure in how many and what exactly tables we have defined with the coulmn CUSTOMER_ID. Instead of checking manually each and every job/Ter...