DSXchange

Try output to a PEEK stage - is it correct there?

Are you using NLS? What is the Oracle character set setting and what are you using in DataStage?

I'm sorry but I don't have Oracle installed here and am working on V8, so probably cannot assist.

DataSets are complex binary files and can only be read within DS. The descriptor file is stored where you specify it, then the actual data file(s) is/are stored in the location specified by the active APT_CONFIG file.

Type 18 might not be the best algorithm to use, it is certainly a slower computation than my favorite, Type 2 (which usually results in a pretty good distribution regardless of key type). What are your keys - do the match any (or none) of the documented hashing algorithms? You can revert to a Type 3...

You can use the DataStage command "orchadm" to do this. The options are: $ orchadmin dump ##I IIS-DSEE-TFCN-00001 10:52:14(000) <main_program> IBM WebSphere DataStage Enterprise Edition 8.0.1.4665 Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved ##I IIS-DSEE-TUTL-00031 10:52:14(001...

When I try to import using Orchestrate Schema (via orchdbutil) my box for database name is not greyed out.

Most likely you are getting the warning with the milliseconds. Add a "Peek" stage to your transform stage and output both your source timestamp column and the result of your StringToTimeStamp() call.

In this case the truss output isn't of any help. I wonder if the job is not progressing because it is waiting for Oracle to complete? If you change the job to not write any changes to the database does it complete? Can you have your DBA monitor the DB while this job is running?

You have already posted these questions in a new thread - there is no reason to hijack this thread with a completely unrelated question. this is the active thread

This is not a DataStage, but a DB2 problem. The relevant DB2 settings can be lookup up at LOGPRIMARY and/or LOGFILSIZ

Ag_Ram - I've already answered too many questions for you on this subject. You need to show some initiative and delve a bit yourself instead of expecting all answers to any questions to be given to you. For example, although it has been suggested several times, you have not looked at any VLIST outpu...

Are there any more warning or error messages, particularly Oracle ones?

binay - I don't know where you read that, but it isn't correct. Each job (and routines as well as other objects) has an internal version number. But "Version Control" is a separate topic which has it's own documentation which you can look at on your system; unfortunately the application is phased ou...

Everyone uses a different definition of a what a "wrapper job" could be. In my case I look at job sequences as wrapper jobs.