DSXchange

Select Col1 from Tab1;

The query looks incomplete for a reference input.
Try converting the SQL to Auto generated and check.

chulett wrote:"not helpful"?

Thanks for the hint, earlier I tried using single quotes and it did not work. double quotes worked.

Hi, The job fails when password has value '#'. The error message on Oracle EE stage is -dboptions option list; failed on Expected "," or "}", got: "#", line 1. Is there any workaround, apart from changing the password? http://www.dsxchange.com/viewtopic.php?t=133122&...

'tasklist' on command prompt - to find the active processes running on the server.

You can replace the transformer by IPC stage if there are no derivations involved Or set the inter process property on Job properties. "Pushdown Automation" --> Work around would be to create a job which reads some constant from dual table and load to a file. In the before or after SQL of ...

Lookup is supposed to return only one row from the reference input. If there are more than one record that matches it will throw warning

Join can be used instead.

convert the negative into positive(multiply by -1), do the same conversion as you did for positive and then convert back to negative.

Convert('"','',Convert("'","",(yourstring)))
unless you want to accomplish the whole thing using only one instance of convert function.

chulett wrote:Not for Oracle.

Thanks Craig for correcting.

Check If any value is assigned to the variable. If yes, then check if the TNS entry is available for that particular DB in your Oracle client installation directory on Datastage Server.

Not sure if UNIX environment variables can be encoded. That might be a concern

Javieregh wrote:Right(myString, Index(myString,"@",1)+1)

Right(myString, Len(myString) - Index(myString,"@",1)) Would have worked.

If the fields have not null contraints you can load an empty string by using '' in the derivation for the fields.

select Distinct ProviderNumber,substring(printerexception,1,50) as PrinterException from providerpmg,AZ_locations where (PrinterException = 'Mon. - Fri.: 8:00 a.m. - 8:00 p.m.; Sat. - Sun.: 8:00 a.m. - 4:00 p.m.' or PrinterException = 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m.' or PrinterException = 'Urgen...

blazDelParis wrote: I've noticed it happens when you have a csv file as input
my csv file is ";"-field-separated....

Did you mean sequential file?