DSXchange

If you haven't dealt with them before, they require all information up front. If a sequence consists of 100 jobs, they need it all. This process can take weeks. We don't have this time so I first poll the forum for any help and at the same time, start the IBM support process. Some times, this proble...

Fun times again.... Config: Parallel running on one node The job consists of two Oracle Enterprise Inputs going into the Difference stage and subsequently into the Switch stage. Dependant on the values, records are inserted or updated. We receive this message sporatically. It's never on the same pro...

it seems like alot of work in place of using the transformer stage. I realize there are optimization issues with the transformer but my volumes are low. Nothing over 600,000 rows. all I am trying to do is add a load date to the staging area. By using a virtual dataset introduces another piece of the...

Hi Ray,

I added a column generator but I am not sure how to get the parameter as the initial value. I tried Epoch but it keeps adding one minute to the time extension of the timestamp. If I can get this to work, I do not need the Modify stage.

Is this what you were referring too.\

Thanks

I used the following syntax in the modify stage timestamp_col:timestamp = timestamp_from_string [%yyyy-%mm-%dd hh:nn:ss] (string_col) Right from the manual. Source is a string parameter field pmTIMESTAMP = 2008-01-31 12:00:00 Target is : STAGING_LOAD_DATE datatype: timestamp Syntax is : STAGING_LOAD...

To resolve my problem, I put the Exception abort outside the loop. For the email my condition are UserStatus = 1 else OTHERWISE. This seem to fix the problem. Not sure why.

I setup a StartLoop sequence as follows StartLoopA => JobA =>Endloop I wanted to use the UserStatus to control the loop. If UserStatus = 1 end loop => Send EMail If User_Status = 2 endloop => Terminate sequence If UserStatus = 3 continue loop until one of the above or LoopLimit reached I can't get t...

I found the problem. It's weird. I copied the sequel to NotePad, made changes to the variable and re-pasted the sequel back into DS. I did a view and the sequel worked. As soon as I make a change to the user sequel in DS , the problem reoccurs. There seems to be problems with the DS editor.

My mistake, it was included. I did not cut and paste properly. SELECT TO_CHAR(A.COGIPF_LOCALTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS'), RTRIM(LTRIM(A.COGIPF_JOBPATH,'/content/package[@name=''LANDSO Metrics'']/folder[@name=''Metric Maintenance'']/jobDefinition[@name='),''']'), A.COGIPF_STATUS FROM CG8_LOG.C...

What is strange is that if I remove the seconds from the variable, the sequel does not complain. I agree, the message is complaining about the fields but it's not the issue. For your question, I provided the sequel below. SELECT TO_CHAR(A.COGIPF_LOCALTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS'), RTRIM(LTRIM(...

It is a timestamp. The exact error is METRICREFRESH_STATUS..Oracle_OCI_0: ORA-00904: "CG8_LOG_COGIPF_RUNJOB"."COGIPF_STATUS": invalid identifier METRICREFRESH_STATUS..Oracle_OCI_0.DSLink1: DSP.Open GCI $DSP.Open error -100. This appears as soon as I add the seconds to the variable.

Oracle 10G Oracle OCI As soon as I put the time segment into the variable, the sequel complains. If I remove the time,the sequel return records but not the specific time variant ones. I can get the sequel to work up to the hours. As soon as I enter minutes, the sequel return returns bogus info. If I...

I created a server job in the Parallel EE version for UserStatus purposes. For some reason the following sequel gives me error. It doesn't like the TO_CHAR line. If I copy the sequel into SQLPlus, it works. Could someone please advise. Thanks SELECT field1 , field2 FROM CG8_LOG.COGIPF_RUNJOB a WHERE...

Yes it is checked. I changed my design. There was a flaw in how the calling program received the abort. It did not catch it. It's works now. I thought the forum was to be informative. Why the wisecrack "I'm sure you will" Like everyone in this forum, we try and learn from others. I respect...

You are correct. DX436 refers to 7.5.1 EE. But in general, the course still deals with the parallel version of the product. 7.5.1 has many similarities with the 8.0.1 version. We discussed partitioning, routines and most of the components that reside in 8.0.1. I would consider DX436 can be considere...