DSXchange

oracle

one more thing........iam using ODBC stage

I have two different tables, one has column name "Time_stamp" and the other one has "Timestamp" and when i import the data , the metadata for these columns is LongNBinary. Even i changed to datatype Timestamp.......it is not working. If it is a reserved type........what is the sy...

Hi,

I have a problem with a column with name "TIME_STAMP" or "TIMESTAMP" in some tables. When i try to read or view from datastage, it says that this "filed does not exists". any hints.....pleaz!

I have oracle as input stage. My ODBC connection is working well and also i can connect from sqlplus on my machine to remote database through ODBC. I was also able to import the tables into datastage through the same ODBC connection.....but when i try to view data from datastage it is giving "m...

I giving 2 inputs to a lookupstage. One is output of a shared container and the other is the db2 source. When i compile the job, iam getting the following error Link meta data must be consistent in order to use Shared Container 'ConvertFunction' Link types must match. Names of columns on the contain...

hi,


I want to join a single column coming from a shared parallel container with 6 other columns comming from a db2 table. Iam using join stage. Will this work? Can i use a shared container as an input to a join stage?


kiran.

but, why i don't have this problem when i get the sample file directly from mainframe through e-mail?

only for some rows

i have done that, but the problem is, it is introduing the CR/LF for the wrapped rows also. I tried both in ascii and binary mode. The rows are of fixed length of 3000 chracters. but the some rows are getting wrapped in to 2 rows with around 1500 characters each.

Hi, I have an issue with my data. I am getting a huge (1.5gb) datafile from mainframe box to unix machine and then from unix machine to windows machine where my datastage server is located. since we have some issues getting file from mainframe to windows (datastage) directly, we have include unix ma...

column order is not changed. only data is shuffled!

Hi, I have an input seq file just passing through the transformer without any changes to an output sequential file. When i do this task with server job, i can see the output same as the input. But when i do this task with parallel job, the output file is scrambled vesion of the input file, i mean th...

thanks ....it is working....i unchecked the "omit" box now. But i don't understand why it is happening to only this job sequencer...In the same project there are many job sequencers.....and there is no problem with them? can u please clarify?


Thanks.

Can anybody explain what does it mean?

Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project SecurityResouceCtr
(Internal Error (81021))


thanks.