DSXchange

The problem is resolved i increased the array size..

But the problem is datastage is propely loading data into the table but it's throwing such warnings.

I inserted data at the database level also it's working properly.

I'm working on Datastage 7.5 with Sybase as the Database. I'm using an ODBC stage to load data into the sybase table. It's properly loading data into it but on the link it's showing as "0 rows,0 rows/sec". But in director this warning is coming: ********************************************...

It's already enabled...

It's already enabled...

I given the DATE column as key also but still the output is same. I think in sequential file stage the key has no significance. I'll explain the job in detail say:My job has one Input and Ouput sequentail file stage in between one sort stage is present which is sorting the DATE column. I have three ...

This is a sort tried only with 10 records with no NULL values.

Is there in a format we need to follow while sorting DATE columns.

Arndw,
Could you please tell me what're the settings you've put while sorting?


Please provide pointers to this...

Sorry for not providing all the information. Yes you're correct i'm using a sequential file stage at input and ouput, and a sort stage in between. I have only one job.The output of the file is nowhere used.. Could you pls tell me why it's not displaying the DATE column data? And one more thing you'v...

First of all thanks for the reply. At the Input file stage(sequential file stage) the SQL type is DATE i've changed it to VARCHAR, similarly for the Output file stage i've change SQL type to VARCHAR from DATE. If DATE type is not there in server jobs then "What's this?" I didn't understand...

I have a job where i'm soring a DATE column using sort stage.
The job is running fine but the sort column(DATE column) is blank at the output.

When i change the datatype to VARCHAR the output is fine.

Can anyone pls tell me what's the problem with DATE columns?

Pls provide pointers to this..

First of all thanks for the reply... The contents of odbc.in file are :- "[ODBC Data Sources] DB2 Wire Protocol=DataDirect 4.2 DB2 Wire Protocol Driver dBase=DataDirect 4.2 dBaseFile(*.dbf) Informix=DataDirect 4.2 Informix Informix Wire Protocol=DataDirect 4.2 Informix Wire Protocol Oracle=Data...

I tried to connect to the Oracle Database through ODBC stage but it's throwing as error as
"SQLSTATE=78,CODE = 0,[Datastage][SQL Client][ODBC] 523 76"

I configured the uvodbc.config file also, but still the same error.

Please provide pointers to this...


Thanks in advance...

I've used this command in a routine "SummaryArray = DSGetLogSummary(JHandle, DSJ.LOGWARNING, StartTime, EndTime, MaxNumber)" It's working fine.The event details are stored in "SummaryArray", i want to pass the contents of "SummaryArray" to a file in Unix. I've used the ...

Thanks ray...
I want to use a "routine" for that.
I searched on the forum but i end up with no results..
Maybe i'm not using the correct keywords.

Could you please tell me the keywords...


Pls help me out ray...

I've a requirement where i need to pass the contents of the log file of the last job ran to some text file.After passing to it i have to count the number of warnings present in the text file.

Just i want the contents of the last job ran not others...

Please provide pointers to this...