DSXchange

thanks for the replies. I made a mistake in the original post. What the overall goal is to write the job name to a text file, format then load it into our data warehouse. What i meant was job status. I've never used the universe stage, but it sounds like it might be what i'm looking for. Is DS_JOBS ...

We've been tinkering with ideas for compiling metrics for datastage. One idea has been to use the DSJ.JOBSTATUS, throwing it into a variable. But i'm not sure where to go from here. What the overall goal is to write the job name to a text file, format then load it into our data warehouse. Any ideas?...

Does anyone know of a way to do this an ODBC stage? The reason for this is that, we need a job that will create and load a table on a DB2 system. The table gets created but bombs when trying to load data. The error message points to a journaling issue. The table is not being journaled when it is cre...

This table has no referencial constraints. I was able to create the table and load a test record into it via my personal user login. I was able to create the table with the production login but received the SQL0551 error when trying to load it. I checked the permissions and the production user has e...

I spoke with our DB2 guy and he is very sure that journaling is not an issue. (I brought it into the conversation a few times) Ok so I'm having problems now with authority issues. The program creates the table, then bombs on a select statement. I'm not sure why it runs a select statement, I would th...

ODBC, sorry meant to mention that

I have a job that is creating a table on an DB2 AS400. It creates the table, but bombs when trying to load the table. The error message is as follows [DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - NM070999 in FDLIBFDR not valid for operation. NM99 = "5414900811...

I need to take a delimited file with four columns and transform it into a nondelimited, one field file. Any ideas?

Thank you for all your help. I just learned that I don't need the CFF stage after all (!!!) I believe the error did lie in the use of varchar data types. I will have to remember that for next time.

the source file will be around 20,000 records. I'm using the CFF stage because the "business" wants it done that way. The whole process is set up through three jobs: (there may be unecessary steps) ODBC (runs a create table statement in our DB2 database) ODBC(runs the query and extracts fr...

Even when I manually enter the metadata values, I still can't see any data when I select view data.

I set up a CFF stage to grab is source data from a text file. I have the column metadata imported from the same text file. When I try to view data, I can see that the column lengths are correct, but the is no actual data. Any idea what might be causing this?

WIll the DB2_UDB bulk load utiliy work for DB2_400?

we are extracting from our Oracle DB. The output does get loaded into a sequential file. Ken's suggestion worked, I did have to change the metadata from decimal to varchar. The original extract was decimal 17.

I appreciate all the help, but none of these seem to work.