DSXchange

Hi there, I have a sequential file stage which I want to read data into 2 oracle tables. table 1 will contain records which satisfy the pk (product#,vendor). I'd like bad records (records missing pk data, or duplicates) to get routed to table 2. I've already got bad records with missing pk data goin...

Thanks Ray,

I'll work on your first suggestion, it sounds a little easier for me.

Thanks much!

Hi,

I've found that the following function works fine in the transformer stage if you want to insert a date into Oracle:

DateGenericToODBC(DSLink9.movementDate)

Hi, I sure hope theres no posting limit in this forum.. I have a job which will read a sequential file into an oracle table -sound familiar?- on a nightly basis. The file has at least 3 rows of header data at the top. The header data contains things like order#,customer# etc.. During the load, I mus...

Hi there, I have a job which reads data from a comma-delimitted sequential file into an oracle table. One of the columns is a date value(format is mm/dd/yyyy ie.1/30/2003). Once the data has been inserted into oracle from DataStage, however, the dates get mangled up (like was: 1/30/2003 now:1/3/2030...

Hi guys, Thanks so much for all of your valuable input. The route i've opted to take is to use the folder stage to read file names and their contents (as one large string) into the oracle backend. Then write a seperate chunk of plsql to parse through the comma delimitted string and process each valu...

Hi there,

Does anyone know of a DataStage function that will read the file names inside of a predefined directory, like a "dir" or "ls" command, then pass each file name into a variable in a given job.

Thanks much!

To reply to Suresh, Hi there, as you can see i'm trying a few methods for getting .csv data into my database.. I've managed to set up a folder stage which does exactly what you'd mentioned: it loads 2 columns into my table, FileName and File contents. The contents are quite huge often exceeding 3000...

Hi guys, Thanks for your suggestions as you can tell i'm a DataStage newbie. Now that I've found the Job Control tab, I don't know what type into it to tell DataStage which directory to look in, to capture file names and file count, then pass the filename as a param to another job. I don't have the ...

Hi Ray, The only thing is that the file names and the number of files will never be known in advance. I've actually come across something new to me:the Folder Stage. In the folder properties I've defined the output(column names, folder path that will contain my files etc..) I've created a link b/w a...

Hi everyone, A quick question: If I have a job that I want to read the contents of all the csv files (all having the same format) in a given directory into a database table, how can I do this? Can DataStage except something like this "/export/home/*" in the file name prompt? Or can I get i...

Thanks guys! That was a big help, As you can tell I'm a DataStage newbie! I just got your helpful posts now. A quick question: If I have a job that I want to read the contents of all the csv files in a given directory into a database table, how can I get it so that where it prompts for file name (Se...

Hi there, I have a Sequential file stage and an ORAOCI8 stage. So far I can import the contents of the sequential file into an oracle table. But I need to be able to check that the character length of one of the inbound columns from the csv file is 12 digits long, and if not then reject the entry an...

Hi guys, Thanks so much for your responses! I forgot to mention that I have DataStage Client installed on my machine. Basically whats happened is that I've been requested to import data into our existing oracle db(but i want to practice doing this on my own local db before i do anything on the netwo...

Hi there,

I will have no network/internet connection.
I have DataStage installed on my pc, and a local oracle db installation.
I'd like to have DataStage "read" a csv on my pc into a local oracle table.

Is this possible?

Thanks