DSXchange

The table access stages can work with SELECT * and then use RCP to pass on all columns. But then what do you want to do with those columns? If you are just going to copy everything to a dataset, or pass in a column name as a parameter and check that for a certain value then making generic jobs is qu...

If you have the output column specified as COMP-3 then the CFF stage will write a packed field to the output file. Please confirm that this is the field definition in your output CFF stage.

Although changing the data type of the date columns to string will solve the reading problem, you will still want to convert this string date to a real date. I would edit the extended attributes of the date column in your source sequential file stage and add a format of "%dd/%mm/%yyyy" so ...

Welcome to DSXchange, apeksha. Your error message looks like you specified the column "SRC_SYS_CD" in your transform stage without using the input link name, i.e "DSLink32.SRC_SYS_CD". In several Stages the link name is not required, but in the transform stage it is a necessary c...

The command line is "orchadmin rm {dataset descriptor}". The documentation describes the "orchadmin" command and its options.

What datatypes does this table contain? Can you try to import a sample tabel with just integer and varchar columns to check whether it might have something to do with datatypes. I had a similar problem this past week where the import crashed and I found that there was a column of type "pdf"...

Did you make any progress on your questions? I'm in the same boat in that I want to implement a condition (I want one of my output links to get an additional column) and have made no progress as the documentation is "lacking" on this subject. I've had success using the conditions in the at...

The file is also a "viewer", since the data is being written a text, so a conversion has taken place. You need to specify a column output format to override the default. I like "%f" (see the documentation for sprintf() for an explanation) http://i766.photobucket.com/albums/xx305/...

does the year/date contain blanks, i.e. "2010 05 20"?
also, could you post an actual command line and the error message?

What datatype are you using in DataStage?

(This is a trick question, since "float" or "dfloat" use a binary representation and only convert to display format when you display the value - which would be the point in time when a conversion to an exponential format would occur).

Are both versions writing to the same database? Perhaps one Oracle installation is using other options if they are different. Also, in the 8.5 version, put in a test transform stage just before writing to the database which has a 2nd output link which has the condition "In.{StringColumn} <> Tri...

The biggest problem with datasets is that users delete the descriptor file (the one specified in the jobs) at the OS-level with a "rm" or "del" command. Unfortunately the actual data is not stored in the descriptor file but in the location(s) specified in the APT_CONFIG file used...

DataStage is just a (very flexible) development tool and it can be used with both a top-down and bottom-up approach and imposes no restrictions of that sort on the design.

DataStage will generally not automatically trim strings. Is your database Oracle? Did you use the same configuration file (DSPARAMS) in both installation? If your database is ORACLE, your setting for "APT_ORACLE_PRESERVE_BLANKS" might be different between the 2 installations and that might...

Is Drive "E" a mounted one? Note that paths are always relative the machine that the DataStage server is installed on, not the client; so perhaps as seen from the server your file isn't on "E\".

n.B. there is no "freeware" version of DataStage that I know of