DSXchange

Art Cabugason wrote:For those who have Ascential licenses bundled with Peoplesoft, could this be a license limitation?

Nope, I have routines that do commands, especially sqlplus, so I know it is not a license issue.

Some further information: I just went back to the project I exported from. I went to Administrator ( the majority of parameters are set to $PROJDEF) and changed 2 parameters - source and target dbconnections and modified the tnsnames.ora file on the server to see the source database. I then ran one ...

I am pretty sure that the Oracle clients ARE backwards compatible. They are not, however, necessarily forwards compatible. Think about it - how can you write a client to access a database using features that weren't conceived at the time the client was written. I do have one suggestion, however. Che...

I have a series of jobs, each of which has a sequencer job and a server job. The sequencer serves to retrieve the value of several parameters (such as last updated dttm and batch seq num) and then submits the server job with these values. These jobs executed successfully on our development Ascential...

Thanks, Kim....

I knew it had to be something simple, but impossible to find in the documentation!

Jeanne

Not really. You have to determine which is new in the job and then insert else update. These 2 need to be 2 different links. From the column names, it looks like you are using PeopleSoft 8.9 tables. If you use the DRS, you do not need to determine whether this is an update or a new row. You can cho...

I am trying to develop a routine that reads a hashed file with 3 key fields and returns the value in the 4th field. I am using READU to read the file, but the read fails, because I obviously don't know the syntax to pass it the concatenated key. Can anyone help?

I wanted to be able to set the parameter here and use it when invoking the next job in the sequence. I didn't use a return value, because I need to set the parameter for 2 different jobs to 2 different values. So, I'm gonna have to parse the return value, I guess.

Thanks, guys.

Jeanne

I am trying to write a routine that reads a hashed file and, if a certain value exists, sets the value of the parameter which becomes the BEFORE SQL in a DRS Stage in the next job in the sequence. (There are other ways that I can think of to do this, but, due to the number of rows projected in the t...

Have you verified that the file permissions haven't changed on the hashed files? My security people are not at all happy with the permissions created on the files and want them changed. Perhaps something is running which modifies the permissions?

Jeanne

Oops - didn't realize this had run to 2 pages and I thought it didn't post

Jeanne

I didn't see this mentioned anywhere in the responses. When I open a new project in Designer, by default, routines are not "shown" in the repository. To make them visible, right click on the repository and click on "Show Routines." Only has to be done once per client per project,...

Your problem could be something other than buffer sizes, etc. I am finding that when there is an error in either the table structure of the insert (missing required field or containing a non-existant field) or in the key structure of the insert, I sometimes get weird, non-specific messages from the ...