DSXchange

I can Import metadata from a JD Edwards 7.3 on db2 an AS400 server....DS does NOT import the FIELD DESCRIPTION for the Tables imported in the repository....There is a ODBC connection to the db2 system...There is another DB2 server we connect to and are able to pull in the field descriptions Would me...

Can we output to a flat file of the following format...If yes how do we do it... 1000 |James |510 2000 |Gary |360 3000 |Terry |760 20 |park Beach |California| USA|8887009 30 |South End |Florida | USA|9008675 4000 |Barry |890 : : : : (: colan stands for following the structure) id | name | code loc i...

I tried CurrentDate() would not work...(It gave me a compile time error)...

Have to add an If Then Else in there and dont want to use Sysdate....Am not sure if I am missing something here with PX....or we not able to execute some routines in DS because we are missing some header files...?

I am trying to get the current date to load into oracle.... I can load the current timestamp by using Convert CurrentTimestamp() into oracle... If I try to extract the date as YYYY/MM/DD from the above command my job comiles ok,,,,but I cant see the converted data.. I used the following command Conv...

Some of the files in the installation path of DataStage have the old user ID's to be deleted. What happens when we delete the user ID's.

Do we need to change the file owners before we delete the id's. Would it be safe to change all the files owned by the old user(user to be deleted) to dsadm.

Can DS read and write to a peopelsoft database? If yes does it need a extra pack?

Thank you,

You guys are faster than other support available.


koojo

Thank you guys.

kcbland,
I am quiet comfortable with basic and not quiet comfortable working with unix.

I was wondering what you mean by fully qualify everything.

The cd commond does not seem to be effective when I use it.

When i do a pwd it shows the projects directory.

Is there any way I can cd to a given directory and then use unix commands (by using DSExecute) on files in a different path.

Thank you

I need to make changes to a shared container. The compile option in the designer is not enabled for me to make the change. How does one make changes to a shared container.

Do we need to copy the code on a new server job and then modify it and make changes out there and save it as a shared container

Thank you.....I need to dig into this. I have never used the BAPI stage and my understanding of the function module is not very good. Hopefully I will be able to move forward..... playing around with the BAPI module. I have that installed and the RFC listener.

How do we call a SAP function module from SAP?

Anybody's done this before.....Is this done from the ABAP extract pack....I have no idea on how to get started on this......


Any suggestions?

I checked the ABAP programme on the SAP server it was running once, the other time there was a SAP kernel stop command issued to it. There was one datastage job phantom and an exclusive lock on the oracle table. These process I found after the job stopped. Makes me think that the job was actualy run...

I have a simple sever job that extracts from a SAP table and loads it to an oracle database. The database tables are huge (greater that 100Lkh rows) i.e the SAP tables and number of records pulled in are quiet large as well. Every Time I stop the datastage job :evil: the status shown is Aborted and ...