DSXchange

I encountered a similar problem but the \' '\ didn't work for me.

This is my query

select coln from table where coln = \'xyz\'

my where clause changes dynamically in the above query containing one or more expression check depending on run time conditions.

Please suggest any work around.

I just worked on this issue by using Isvalid function. When the type string is numeric and value string is numeric then this warning will not appear. But when the type string is decimal and the value string doesn't have any precision, this warning appears. Warning Message: "APT_CombinedOperator...

Hello: When I try to parse the decimal values through Transformer stage while retrieving the rows from CFF stage, I am getting the following error. APT_CombinedOperatorController,1: Parsing parameters "" for schema type "decimal": Expected precision; got: <eof> Please advise.

chulett wrote:There should be an APT variable to "preserve blanks" from what I recall. Ah, yes, found it - set $APT_ORACLE_PRESERVE_BLANKS to TRUE. ...

Thanks Everybody.

Using $APT_ORACLE_PRESERVE_BLANKS to True, I could successfully load the data.

When Blank is supplied for a Column F1 which is of Char 1, the Oracle Enterprise Stage treats that as a NULL and rejects. This happens only when the Write Method is Load.

Any suggestions to avoid the rejection of records with column having space.

ray.wurlod wrote:Welcome aboard. Search DSXchange for more information about what you can and cannot do with the command line interface.

Are you running version 8.1? ...

Yes I am running V 8.0.1

How do you export and import datastage components folder wise in V8.x by running from command line?

Reason: The import command from the command line takes enormous time since the number of modules involved are 3000. The modules cannot be splitted into individual projects.

Please advise.