DSXchange

Hi Ray, Thank you. I am using English. My post was incomplete, this message is complete: UP_PESS_TELEFONE,0: Resource bundle corresponding to message key CONN-NGBR-00002 not found! Check that DSHOME or APT_RESPATH is set. UP_PESS_TELEFONE,0: ?? (IIS-CONN-ODBC-000004; ODBC function {0} reported: SQLS...

Yes, I can find an entry in the user's crontab or at. I will contact the official support.

Thank you,

I am using DataStage 8.1 on Unix AIX
I have a problem with the schedule. After I schedule a job, I click the button "schedule view" but don't appear nothing as schedule, however the job execute in the time scheduled.

Thanks and Regards,

Luciana

I have used job parameter in the ABAP stage in DataStage 7.5 and the job work fine, but when I need to edit the query I need replace the job parameter with the value.

Include "*" before the line Call DSExecute ... and print the ucom1 variable. Check if the command is right.

In transformer stage change the property "preserve partitioning" for Clear.

Yes, there is. Look in the c:\Program Files\Ascential\DataStage7.5\

You can to use Oconv or Iconv only Server Routine (Basic language) or in transformer stage. Parallel Routines must be create in C.

Hi,

I want to extract through where clause used in a project all jobs do we have with status running

Thanks in a advance,

Luciana

I don't know if it will be faster, but it was a recommendation of a consultant IBM.

I include the other columns in the code and the job it executed with success.

Thanks a lot.

Luciana

Yes, I can, but I have a DataStage Job that the transformer is very slow then I want replace the transformer stage for a buildOp stage, but neither all columns have transformation, then I make this simple BuildOp Stage for test.

Thank you,
Luciana

Hi, I have a simple BuildOp Stage that multiply two columns. This job execute fine but the output is not correct. In Sequential File there are three columns, the Amount is correct, but the another columns receive "0". These columns must pass without changes. I don't understand where is the...

I have the same problem with one job that use Complex Flat File Stage. I import the table definition and one column appear as DISPLAY NUMERIC, but when I press OK and after open the properties, this column appear as DECIMAL. The job execute with no warnings, but the size of row stay incorrect. DataS...

If you to specify the Quote Character property (on the Format tab) as double ... In jobs server, the DataStage places quote character in the fields of the type char or varchar, not integer. Field1(char);Field2(integer);Field3(char);Field4(integer) "AB";123;"DS";100 "AC"...

Hi Goutam

Try to use the function GetEnvironment('ORA_USER_SID') with this sintaxe.