DSXchange

Hi All We are getting source data from JDE EDWARDS. In that we have 3 columns like (Source) Column Datatype length DDDD binary 4 YYYY binary 4 AAAA binary 4 SSSS binary 4 in oracle (target) Column Datatype length DDDD varchar2 20 YYYY varchar2 20 AAAA varchar2 20 SSSS varchar2 20 how to covert binar...

Hi All We are getting source data from JDE EDWARDS. In that we have 3 columns like (Source) Column Datatype length DDDD binary 4 YYYY binary 4 AAAA binary 4 SSSS binary 4 in oracle (target) Column Datatype length DDDD varchar2 20 YYYY varchar2 20 AAAA varchar2 20 SSSS varchar2 20 how to covert binar...

HI All,

How to convert Static Date to Date format.

I have a specific requirement to insert the constant date into the oracle 9i

How to insert the constant value '31-Dec-9999' using the transformer stage into the oracle 9i table


Thanks,
srini

aditya wrote:Srini,

Do you have the Peoplesoft E1 PACK available? If so I could illustrate the steps needed.

-- Aditya.

Hi Aditya,

Thank you

We are trying this is it possible "for DB2 on AS 400"
Thanks in Advance.

Hi All

" How to read JD-Edwards source from ETL DataStage"

I Tried source data read from DB2 and Load in to Target Oracle 9i

but it is not getting connected,Please suggest me how to do this in DataStage.

Thanks in advance

srini

Hi All,

Could you please look into this

" How to convert julian Date format to Oracle Date format "

Thanks in Advance
srini

Hi All

We have implemented Inactive timeout for 4 hours in DataStage Client session.

Will this prevent the designer jobs being 'locked' when we lose our connection from VPN?

Regards
srini

It's not hashed file allowing nulls. It's that you are trying to write the nulls from the source column into the hashed file( If I understood what you have written correctly). Define a constraint saying Not(IsNull(Hashedfile.Key)) That way, you won't be processing all those rows whose key value is ...

Dear All, Could you please let me know the root cause of this problem In our Jobs Hashfile As a key coulmn and remainng three coulmns hardcoded to '0' ,even though that hashfile key column is allowing null values from the source becuase of that jobs are getting aborted!!! help on this Thanks and Reg...

Hi we are using Constriant like Linkname.coulmnname =0 OR Linkname.coulmnname =0 Or Linkname.coulmnname =0 is this way is possible to handle nullvalues into notnull column. Regards srini Oracle will interpret an empty string ('') as NULL. In DataStage an empty string is just an empty string. Mike

Hi All, Our Datastage jobs are got aborted couple of days becuase of this below problem. IncLotsHashToTable..Dstage: ORA-01400: cannot insert NULL into coulmns but As this is a not null column and since null values are trying to get inserted we are facing this problem. in that column we did constrai...

Is there a way to find out who has cleared the log ?

Hi All,

Accidentally someone cleared the dslog file entries.Could you please suggest me how to recover " Cleared Log Entries "

Regards
srini

Hi ALL,

I have a single job in that, I had used 5 transformations to implement the business rule, I would like to know how many number of process will run back-end.

Regards
srini

Dear All,

PRINTER memory segment removed
DataStage Job 74 Phantom 22242
DataStage Phantom Finished.

I am getting this error while reading source data to MQ series and put into file.

If any help It would be a great help to me.

Thanks and Regards
Srini.Y