DSXchange

Yes all 100 are loaded but Amount column is loaded with 0.

Hi All, We have a Job, which is loading from a flat file to Oracle table, which is one to one loading on all the column with some trim functions used. Here in the table we have column A datatype Decimal (38,5) in which amount have to be loaded. When I try to load, only few records with amount is loa...

PLEASE HELP !!!!! I have installed Data Stage 7.5.2 on XP pro SP2. I get this error "This Jobtype is not currently runnable on this platform" when I want to run parallel job. Although, it a simple job type reading a sequential file (.txt) , the above mentioned error displays. Please help A...

What is kernel settings? What is the use of this? What are kernel parameters in datastage?

Hi,

I wanted to know what is the maximum number of nodes we can use for a job? What is configuration file? Can we edit it? If yes how can we edit it?

I am fetching rows from the database and writing it to a dataset with copy stage in the middle. the SQL select gives the following result Column1 Column2 997000045147278 223319.43 in the dataset when i view the data its shown like: Column1 Column2 997000045147278 0000000223319.43 zeros are being ad...

After I remove the trim also. It is giving me the same error.
Please can you suggest me on this.

Yes it is compatible with Oracle 11g.

It is not compatible with Oracle 8i.

You can use StringToTimestamp.

You can use stringtotimestamp.

No I am not using any bind Variables.

Yes I am using a Transformer and using trim function also. how does it makes the difference.

Hi, When I am try to call a procedure from ODBC Stage in Data Stage PX. I am getting the following Error: Error executing View Data command: ##F TFPM 000279 16:41:01(019) <main_program> Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: In field: Expected identifier, got: &qu...

But in the help file it as been given to add it to the Job Parameter.

Can you please let me know the work around for the stored procedure.

I am having a stored procedure of SQL Server. I am trying to use the stored procedure stage. Problems I encountered are: 1. There is no SQL Server in the Database Vendor. (Work around I have given that in the Job parameter). 2. Error while running the Job is: Stored_Procedure_6,0: Error: Unknown cli...

It is a simple query.

SELECT A1,A2 FROM DEMOTEST1;