DSXchange

Hi I am reading a fixed width file by removing a Header and Trailer record by placing a filter condition as grep -v HDR| grep -v TRL in the Sequential file stage,so it will be removing the header and trailer and i can able to process the detail records successfully But in the case of without detail ...

Thanks Ray!

Does the join stage use the sratch disk space for doing the join operation or it uses the database temp space or it dont use temp space and just do the join and display the results "on-fly" with the database

Thanks in advance.

Hi Guys, In join stage, i am aware that the parallel engine will insert a tsort operator to do the sort operation, which in turn requires temp space in scratch disk to store the temporary files. If i dont do the sort operation by giving "dont sort environmental variable", temp space wont b...

Arvind,

Could u please tell what u mean in this statement " create the flat file sequence within the scope of datastage ". U mean to say i have a create a file using only surrogatekey generator in a job, with some values in that?

Thanks in advance.

Hi Guys, Sequential file ---> SurrogatekeyGenerator(SKG) --- > Dataset Inside SKG, i gave the file initial value as 1 and output column as surrogatekey. From the source i get 2 column registerno,names which comes from sds.txt.. In SKG, for source file name i gave an empty file name sdf.txt. I ran th...

Hi there! I have created my project with my user id and ran the job with dsjob command through script successfully . Now same job when i tried to run with functional id i am getting the following error, Failed to open project. with some status code..(sorry forgot the status code) Could you please he...

Chulett, Please find the error message below.. ##E IIS-DSEE-TFOR-00001 05:00:28(000) <Data_Set_0,0> Failure during execution of operator logic. ##F IIS-DSEE-TFIO-00161 05:00:28(003) <APT_CombinedOperatorController,0> Fatal Error: I/O subsystem: Open of /D=/IBM/InformationServer/Server/Datasets/RELTT...

Hi all, In my job, am loading a dataset with 4 million records. In between a lookup is there where partitioning is hash and after that its "same" till the end. Now when i tried to read the data from the dataset, i get a weird error like "No such file or directory".. But it happen...

Hi There, We exported a unix variable for eg f_iname=a in unix i have added the userdefined environmental variable in Admin client as f_iname without default value in my job paramter set i have added the above $f_iname user defined env variable ,setting default value as $ENV when i am running a job ...

Ray,Chulett,jwiles

Can you people atleast reply for my issue.


Thanks in advance

My datastage version is 8.0.1. Expecting some reply in this issue. Please advise.


Thanks in advance

My ddl : create table test1 ( id number, ship_xml clob ); Ds design : Oracle source ----> Oracle Target Source query : select id,dbms_lob.substr( ship_xml, 4000, 1 ) as ship_xml from akrishb.test1 I used the above query as the job failed when i tried with ship_xml alone giving the following error. O...

My query : In email notification stage, is it possible to give status mess dynamically.. Another query: I understand this is not the right place to ask about where i can find the guide for sequencer stages. But i am unable to find one. I am able to find only for job processing,database,file and debu...

Hi, " Typically InfoSphere DataStage would use round robin when initially partitioning data, and same for the intermediate stages of a job " from parallel jobs developers guide. So i went for partitioning logic myself. Job design: Source ---> lookup1 (2 reference tables) ----> lookup2 ( 2 ...

i have tried loading with dataset but performance is still same (1900 rows/sec). We have discussed for BCP but there is storage memory issue so we can't choose that option. Is there any other way to boost the loading?