DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 79 matches
Author Message
 Topic: Using table name how to search the related Jobs
irajasekharhexa

Replies: 2
Views: 1779

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 24, 2010 11:19 am   Subject: Using table name how to search the related Jobs
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 ...
...
 Topic: Using table name how to search the related Jobs
irajasekharhexa

Replies: 2
Views: 1779

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 24, 2010 8:03 am   Subject: Using table name how to search the related Jobs
DataStage® Release: 7x
Job Type: Server
OS: Windows
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 sha ...
Resolved
 Topic: ASCII Data -Cobal Copy book
irajasekharhexa

Replies: 4
Views: 2060

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 25, 2009 12:58 am   Subject: Is it possible to share the copybook
Are all records of same format ?

Is it possible to share the copybook
Resolved
 Topic: ASCII Data -Cobal Copy book
irajasekharhexa

Replies: 4
Views: 2060

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 25, 2009 12:58 am   Subject: Is it possible to share the copybook
Are all records of same format ?
 Topic: Operator Error
irajasekharhexa

Replies: 1
Views: 1967

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 31, 2009 11:32 pm   Subject: Operator Error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 ...
 Topic: IDOC interface functional module
irajasekharhexa

Replies: 0
Views: 1073

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 20, 2009 2:25 am   Subject: IDOC interface functional module
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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 BAP ...
 Topic: Loading into Packed Decimal Field
irajasekharhexa

Replies: 1
Views: 1179

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Jun 24, 2008 1:20 am   Subject: Loading into Packed Decimal Field
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Oracle Stage Insert Update and Delete
irajasekharhexa

Replies: 3
Views: 2907

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 12, 2007 5:55 am   Subject: Oracle Stage Insert Update and Delete
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 th ...
 Topic: EBCDIC TO EBCIDIC
irajasekharhexa

Replies: 8
Views: 2991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 11, 2007 2:31 pm   Subject: EBCDIC TO EBCIDIC
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 so ...
 Topic: EBCDIC TO EBCIDIC
irajasekharhexa

Replies: 8
Views: 2991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Dec 06, 2007 9:11 am   Subject: 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 ...
 Topic: EBCDIC TO EBCIDIC
irajasekharhexa

Replies: 8
Views: 2991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 29, 2007 11:52 am   Subject: 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 ...
 Topic: EBCDIC TO EBCIDIC
irajasekharhexa

Replies: 8
Views: 2991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 29, 2007 11:51 am   Subject: EBCDIC TO EBCIDIC
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 ...
 Topic: EBCDIC TO EBCIDIC
irajasekharhexa

Replies: 8
Views: 2991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 26, 2007 11:29 am   Subject: EBCDIC TO EBCIDIC
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 fi ...
 Topic: Finding a particulor column in all the Teradata tables
irajasekharhexa

Replies: 4
Views: 2148

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Nov 09, 2007 5:43 am   Subject: Finding a particulor column in all the Teradata tables
Thanks lot.

It's solved the Issue.
 Topic: Finding a particulor column in all the Teradata tables
irajasekharhexa

Replies: 4
Views: 2148

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 08, 2007 10:57 am   Subject: Finding a particulor column in all the Teradata tables
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 exa ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours