DSXchange

irajasekharhexa

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 ...

Thanks for the information Chullet....

irajasekharhexa

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

irajasekharhexa

Sainath.Srinivasan wrote:Are all records of same format ?

Is it possible to share the copybook

irajasekharhexa

Sainath.Srinivasan wrote:Are all records of same format ?

irajasekharhexa

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

irajasekharhexa

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?

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

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...

irajasekharhexa

Thanks lot.

It's solved the Issue.

irajasekharhexa

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...

DSXchange

Search found 79 matches

Using table name how to search the related Jobs

Is it possible to share the copybook

Is it possible to share the copybook

Operator Error

IDOC interface functional module

Loading into Packed Decimal Field

Oracle Stage Insert Update and Delete

Re: Thanks

Thanks

EBCDIC TO EBCIDIC

Finding a particulor column in all the Teradata tables