DSXchange

I have one text file with 3 different layouts. content of the file: the first 5 lines contain header information (layout 1) line 6 to 20 contains detail record information (layout 2) line 21 to the end contain trailer information. (layout 3) how can I read all three formats from the same sequential ...

Can someone help me to figure out how to update the job version number in a datastage job. My team works on change requests which modify datastage job. Once a datastage job is modified, we will update the job version number to the next value (eg. 50.1.1. to 50.1.2) and release it to prod. version nu...

It is installation of all 3 tiers and client tools on a Virtual machine. I am using Virtual PC 2007 (Microsoft). Certainly I can check if there is any antivirus or firewall turn on, but dont' think so. I saw the screen where it said it was going to check the components after I put in the license fil...

I have set up a virtual pc running WinXp. Now I want to install datastage 8 on it. The issue I had was that after I inputed the license file, the next page was suppose to list all the products that I was licensed to install. But it became a blank page, so I couldn't see my selections. Anyone has sim...

dxk, can you give me an example of what you mean. yes, all the records have are fixed lengt. ray, the format is already Oracle native format. I can use sqlldr to load the file, but I can't load using datastage Oracle Enterprise Stage. Stages that I used: Sequential file (read csv in) -> Transformer ...

I have a datetime field that looks like "12-JUL-09 07.02.00.000000 AM" and store in a csv file (that is the source file). My target is an Oracle table. the above field is defined as "timestamp" in the Oracle table. I have problem loading the source field into the target table. Wh...

I need suggestion on the "Passing the id down". Not SQL.

thanks,

yes, it is a bit generic. We have a database table that stores unique batch IDs and other attributes on Oracle DB1. Every batch run will kick off a list of child processes that populate tables in Oracle DB2. All the child processes should capture the same Batch ID number and store them along with ot...

hi gurus,

I am tying to query a database table to get an unique process key to pass to downstream DataStage Parallel processes.

How can I do this? Can you give me some suggestions.

thanks in advance.

Apparently the Oracle Enterprise Stage uses sqlldr client.

Once we reinstalled the Oracle Client with all its utility and software. And retried running Oracle Enterprise Stage job. The issue was resolved.

I am using g++ compiler on Solaris 10 and I can't compile yet. The compilation error stated that -KPIC not support. I didn't put it in the Linkeropt or compilerOpt. I wonder where that is set and how can I get rid of it?

thanks in advance.

yes, I added ORACLE_HOME to dsenv, and then stopped and started the engine.

yes, i used sqlplus on Solaris to connect to oracle db and it worked fine.

I followed the configuration guide to setup Oracle Enterprise Stage, but it is not working. I did the followings, basically whatever listed on the IBM Installation and Configuration PDF that come with the installation. 1) add ORACLE_HOME to environment 2) add ORACLE_HOME/bin to PATH to environment 3...

hi guys,

I need to write out numbers to a sequential file with commas.

eg:

input -> 1000000

output -> 1,000,000

Is there any function in transformer that I can use?

thank you,
aggie

the link from Sima has the answer on what to update for LIB and INCLUDE path.


note: for .NET 2008, I used the .NET 2005 instruciton and it works.