DSXchange

Hi All, We were using IBM Information Server 8.0.All jobs were running fine. Our jobs have got huge sql queries.We were using Oracle 9i database. But now we want to migrate from 8.0 to 8.1. Now when we run the jobs especially the jobs which have got Oracle Enterprise edition stage throws an error. B...

Hi All, I am trying to extract the metadata of all the projects by using the following command. 1.dssh "SELECT SCHEMA_NAME,@ID,PATH,OWNER FROM UV_SCHEMA WHERE SCHEMA_NAME <>'CATALOG';" > ./file1 I am doing the following test case:What happens on deletion of a project.While testing,I found ...

Hi, I am trying in IBM Information server the following.Just to try TCL commands through scripting. cd to the bin directory of the dsengine typing the following command. ./dssh.exe SELECT * FROM DS_JOBS > file4.txt Just testing on the TCL commands. File gets generated but could not see any data. Any...

Hi, My enviornment is like this 1.No sequence 2.We use a routine to run the jobs. My requirement I need to trace the parameter name which is used by all jobs Approaches 1.Take a dsx and search for the names of the parameters. 2.Write a routine which gets the names of the jobs in the project and the ...

Hi, Thanks for the reply.Sequential file stage and the length i am specfying is 8000 for the XML column.I did another test used sequential file stage datatype as varchar 8000,removed all the other fields expect for the XML column field and written the results using another filestage.Used the strip r...

Hi All, I am having a source file like this column1,column2(xml tag),column3. I read it and pass the column(xml) to the xml input stage and then to the targets.The job aborts after reading a million rows and throws the "ACCESS VIOLATION ERROR". I guess these are some data related issues.I ...

Hi,
Its compile time.During view data itself its not accepting.

Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project Test

Regards,
Bala.

Hi, Thanks Craig. I cant enable the supress row truncations as data is not read fully. I have used some of the delimters(144 or 161) suggested in the below link.These are very rare to come from the source. No worries my data is Engish not french http://www.asciitable.com/ Out my curiosity where can ...

Hi, I have a file in the below mentioned format. UHDR1 1234567890 AB1CD12345 ABCDEFGH ABC@ABC.COM UTRL1 Since the Header and Tralier Format is going to be the same for all the files,I am creating a template job to remove the Header and Tralier. Below is the design 1.Read all the records as a row usi...

Hi,

Its a strange problem even once i have got.Click on the the data definitions first,the canvas(data definition) will open and then try it should get enabled.

Bala.

Hi, Thanks for the reply.It was absoultely an issue with the source columns which was having a CLOB datatype.I have to substring the columns instead of type casting it from CLOB to varchar.Once when I type cast it could read all the records.Apologies if I was not clear in my previous post. But still...

Hi, I have an ODBC(Oracle DSN) for sourcing data.When I write to the target sequential file stage. The following happens 1.Job Aborts 2.It sources some records. 3.It gives me the following error. src_ORA_Desc..Seq_Trg_Desc.Outto_Desc: read_delimited() - row 440, column CL_CORE_CD, required column mi...

Hi, Thanks for the inputs. Let me give my approach. Enviornment 1.Using parameter.ini file to set the parameter values. 2.No datastage sequence.External scheduler. My approach, Filter comes from one table.Need to separate the filters using conditions As craig suggested i am going to read the inputs ...

Hi All, Is there a way of passing the values from the hashed file to the Where clause of the sql. Let me explain 1.My source system is like this table1------table2 table1-------table3 table1 -------table4. All are related through primary key(table1 pk in table2,table3,table4) Filter condition for my...

Hi, Thanks for the command.I am not doing anything at the transformer level only at the target stage changing the Quote character from " to 000 in the format tab of the sequential file stage.My concern is about the strange behaviour of datastage.Just want to know the ghost :twisted: behind this...