DSXchange

Hi, my jobs keepon running while reading oracle table. this is inconsistant some time it is working fine some times it is not. I have varchar 1 filed in my source table. i have changed that filed as last coumn in my select query then it is working fine. Please let me know what could be the reason. N...

I am trying to import PL/I file structure but i am getting error while importing fthe following column

PIC '99999V.9'

Error msg: PICTURE CLAUSE contain unsupported character
This column is 7 character lenght..

I have a EBCDIC source file with header, trailer and details records with same record lenght but different coumn list metadata for header and detail reocords. Is there any why i can split these theree types in Parallel CFF stage?

Hi All, I have a job "job1" which i want to run multiple instances in Job sequence, which has four job parameter. In that four parameter, one parameter is for SQL query to extract data from tera database. For that i am using a shell script to invoke that job, the job is running using the s...

It is fixed length columns

my source file is a fixed width file. it will contain both numeric and character data. i am trying to view the data but all column data comming in first column..can i use seqential stage in parallel job.
please let me know if anyone know ans..

Hi, In my project, my extract team is going send source data in Ascii format fixed length flat file.But as of now i have only cobal copy book for the ebcdic format file for file definition to start development.Will it be ok if i load copybook ( contains packed fields) using DS manager and load metad...

I need to update job control table with job name, starttime, endtime, job status. Please anyone let me know how can do this.. I want this routine to call in sequencer not in before after routine for each job.

I am getting "verb UNLOCK is not in your VOC" msg while i was trying to unlock job. Can any one explain why i am getting this msg.

Thanks
kame

Can anyone tell me new features added to Datastage 7.5.1A version in addtion to the Datastage7.5.1

limitations on handling different data sources,handling huge data, speed etc

Can anyone tell me are there any limitations in datastage tool
Thanks
kamesh

I want to check some spcial characters in a column.. like i want to check
characters not in ([a-z],[A-Z],[0-9],!<@,#,$<%,^,&,*,(,),>,<,?,,.,/)like this..
pls anyone help me out how to do this using datastage

Thanks
kamesh

Can any one tell me how to take only year from the system date?
Thanks
kamesh

Hi,
Can any one tell what are the other export file types in datastage other than dsx file?
Thanks
kamesh