DSXchange

I am familiar with the sequence function in the server environment, is this done using the surrogate key generator stage, and if so, is the last number used saved somewhere or does is have to be derived at the beginning of job where the sequence is needed? The Surrogate Key generator has a 'start v...

Sorry...thought I selected the Enterprise Edition and not Server edition. Should have looked harder, my bad!

when running a job, I get the error below... LU3: When checking operator: The view adapter has a binding for the non-existent destination field "PA_REQUEST_ID". I do not comprehend why because the mappings is as follows: The main Input is PA_REQUEST_ID TIME_IN PROGRAM_NAME ... ... STATUS_N...

I created six(6) stage variables, probably could have gotten away with less to accomplish my task.... svCreatedOn := nulltovalue(lnSeqCode.CREATED_ON,"01/01/0001 12:00:00 AM") svCrOnHr := trim(svCreatedOn[Index(svCreatedOn,":",1)-2,2] ," ","A") svCrRestOfTime ...

I have some flat file data that contains timestamps in the form of "YYYY/MM/DD HH:MI:SS AM/PM". I need to convert it to Oracle timestamp In the target Database. Using a server job, I simple created a routine to do the transformation. However, the requirement is to have it done in a paralle...

In the Database I defined the column as NUMBER. When I imported the table into DataStage, that same field gets created at decimal(38,10). Where is that translation being set, I keep getting errors/warnings on the field. How is it that Datastage 'changes' the type from Number to decimal 38,10. Is the...

Another Error I get is this: CONV_LD_DIAGNOSIS,0: Column LAST_VAL floating point decimal is not fully supported; adjusting the scale. f I make it an integer, I get a conversion error. If I make it a Decimal I get this error. If I make it a varchar, it will be incorrect in the DB. Is there something ...

thanks Ray for the (partial) response.

Unfortunately my company does not want Premium sponsorship so I could only see the first few sentences. Is there any other way to get a response that we non-premium dsxchangers can view?

A parallel job running into the following... I have a field in a table defined as follows: CREATE TABLE diagnosis (diagnosis_iid NUMBER, I have a select that is as follows: (SELECT nvl(MAX(DIAGNOSIS_IID) ,0) LAST_VAL FROM #SCHEMA#.DIAGNOSIS) The job contains one transformer and the field is mapped t...

kumar_s That is another issue in and of itself. We brought the server down and back, ran some of the rebuild features, looked into DS.TOOLS, and cleaned out the &PH& directory. I also deleted some old sequential files in the project directory. After all of those were completed, the error van...

We have mulitple projects on a single server. One of the projects starting to get an error message this morning. All of the other projects appear to be functional. The error is: Error calling subroutine: DSR_PROJECT (Action=8); check DataStage is set up correctly in project XXXXXX_XXXX_XXXXX(Name ch...

We have User Define SQL tht was a copy/paste from the Update Existing/Insert New Action on the ORacle OCI 9i Stage. When we run it as User Defined, the job aborts and when we run with Update Existing/Insert New it runs to success. Has anyone else had or seen this issue? We are on DS 6.0r4 There is ...

We have User Define SQL tht was a copy/paste from the Update Existing/Insert New Action on the ORacle OCI 9i Stage. When we run it as User Defined, the job aborts and when we run with Update Existing/Insert New it runs to success.

Has anyone else had or seen this issue?

We are on DS 6.0r4

Hello Friends, I'm not able to open properties box of any stage of a sequencer. server is not reponding . I am not gettinig any message or error. Unable to design new sequencers, old sequencers are running ok. Appreciate If anybody can suggest something on this issue. Thanks! We are having the same...

Mr Kim.

If you could get the source, or at least some of it, that would be wonderful! In the mean time, I will investigate the options that you have suggested! Thanks

email: zam62@yahoo.com