DSXchange

Thank you Ray. We are using version 6.0 We recently created a new project and this happens only in the new project. So, before re-indexing all the users should be out of datastage?

Thank You,
Gregg

Hi, I get the following error while trying to export jobs from datastage manager using the option 'Export by Category'. Error calling subroutine: *DataStage*DSR_SELECT (Action=7); check DataStage is set up correctly in project develop (Subroutine failed to complete successfully (30107)) This happens...

Hi, I need to update a oracle table from datastage routine. After going through earlier messages in this forum, I tried running the following routine: strLogin = DBUser : "/" : DBPwd : "@" : DBSid strUpdate = "update myschema.mytable set myflag= 'Y' where mycolumn ='" :...

Hi, Thank you for your response. But the idea of copying the job and deleting the stage is not working as well. My job design is as below: SeqFile --->Transformer(with 7 reference inputs) --->Sort ---> SeqFile I am not even able to see the properties of the transformer. Since the entire logic is in ...

Hi, I have a job in which I am using a sort stage. When I try to delete the sort stage datastage doesn't do anything. I am not even able to look at the properties of the stage. The same is the issue with the transformation stage in the same jobs. I tried exporting and importing the job. It doesn't w...

Thank you Ray. That worked perfectly.

-Gregg

Hi Ray, Thank you very much for your response. I'm sorry if I was not clear in stating my motive. I am using Oconv(TheDate, "DWA") to know the weekday. For eg: Oconv(Iconv("2004-06-28","D-YMD"), "DWA") gives me Monday. But my requirement is when the day is &qu...

Hi all, I am trying to find what was the previous weekday from a given date. For example given today's date, I need to find what was the date on last friday. One crude way I could think of is to find the weekday of the given date and then subtract the respective number of days to get to last friday'...

Hi,

Sorry for the delay in getting back to you. I have finally divided the one job into 3 seperate jobs each loading a different table. That seemed to be the straight forward way to solve my problem of the log info.

Thank you Chuck and Kim for your attention.

-Gregg

Sorry for not providing that information earlier.

All the three tables have the same layout. But the update action is different for each of the tables. Hence the need for three seperate output links.

Thank You,
Gregg

Hi, I have a job that loads data from a flat file into 3 different Oracle tables(same columns in all 3 tables) depending on some conditions. For ex. if X =1 load into Tab1, if X = 2 load into Tab2, if X = 3 load into Tab3. To implement this I have one input link to a Transformer stage and then 3 out...

Thank you very much Ray. I got it working now and I have also replaced the substringing with a single Oconv. Really appreciate your timing and deep insights into the topics posted.

-Gregg

Hi, When we need to backup all of our DS projects do we also have to make a backup of the &PH&, &COM&, &SAVEDLISTS& directories? Are there any tools available for automatic project backups? Essential what all files does an ideal backup need? Appreciate your inputs. Thank You,...

Hi, I am trying to develop a routine to get the last day of the month in the format yymmdd. For this I'm using the built-in transform "MONTH.LAST". The main prupose is to provide the output of the routine as a job parameter in a sequencer job. The code for the routine is as follows: DEFFUN...

Hi Ray, I fully understand when you said "So the pid in the Capturexxxxxaa file may not have a record in &PH&. ". I tried to break my job voluntarily and then observed all the capture files that were being generated. Then I went back to check that pids of atleast some of the captur...