DSXchange

Ok, so far pretty good, but I'm getting an odd error. I've created a parameter set with PARAM01 - PARAM08 in it. My DS job is using this parameter set. However, the sequence is bombing with the following error: Exception raised: @Load_Job, Error calling DSSetParam(PARAM01), code=-3 [ParamName does n...

I should have said, you cannot do this in a job activity. If you need a fine degree of control on your parameters, then you need to program it in BASIC yourself. Although the source code for what a notification activity is visible (go into your Sequence in the designer, open up the detail window an...

ok, I think I now know what the problem is, so need a solution. Our Job sequence has been designed to be dynamic so that our scheduler program can execute the sequence which will: 1) Job Activity (Pre_Row_Count): capture a pre-load count of the desired table using a dynamic DS job 2) Job Activity (L...

We've got a sequence containing a Job Activity that passes 7 parameters (with the last 5 being optional). This works fine. However, once we add a 6th optional parameter (8 parameters total) the sequence fails to finish as it can't find the job to run in the Job Activity. Is there a limit to the numb...

I've got a sequence that is as follows: Job Activity -> Nested Condition -> Notification Activity The Nested Condition is set so that if the status of from the Job Activity (which executes a DS parallel job) is greater than '1', then an email is sent from the Notification Activity. This has been suc...

You need to do your counts in a separate job store in a table with todays date. Do a comparison to the max and the next to max date. This will compare last run to this run. If you don't know how to do this then let me know and I can post the sql. There is sql like this in EtlStats. If you've got th...

Sorry for the delay, but I got sidetracked with other projects. Does the fact that I'm running a parallel edition of DS have any bearing on this? We used to be in server, but going to 9.1 we switched over to parallel and hope to harness some of its capabilities. Should I create a parallel routine fo...

It was my understanding that by going into the 'Job' tab in the Job Activity stages of a sequence and setting the 'Execution action:' to 'Reset if required, then run' would allow the sequence to be reset. Now, I'm thinking that the above only resets the specific Job Activity and not the status of th...

Specify Double as the data type the DataStage table definition. Some databases, including Sybase and SQL Server, report Float for DFloat data types. This worked. I previously understood that Double was reserved for very long numbers. Is using Double a best practice here due to the nature of SQL Ser...

Good Morning, Ray. Thanks for the response. Essentially, we want to evaluate strings and provide blank when there is no data. Usually Nulls are desired, but we have several clients that prefer blank which is why we wrote this routine. We could do it with a series of statements in the transformer, bu...

I have the same issue. I'm reading a source table with a column defined as a FLOAT in SQL Server Database using ODBC Connector Stage. Exact same definition as post in the OP. What is meant by 'cast to decimal type in query'. Is this writing an SQL query and doing a conversion on the column from a FL...

In 8.7 Server Edition we have created a routine that will evaluate strings for blanks, nulls, or empty and return blank. This routine works fine in 8.7, but now working in 9.1 Parallel Edition I'm wondering if there is a function or pre-existing routine that does this? Is there a way to access this ...

Perhaps there is no issue, but then I likely don't have a real understanding of the Job Activity. The way I understand it, the Job Activity requires a job name to be selected and only the parameters for that selected job are available in the sequence. (The hard-coded job name is then manually replac...

A bit more specific. We are building a sequence that we'd like to have be fairly generic to handle multiple job types. Most of our jobs delete all the rows on a table, then load the table with new data. However, we have some jobs that don't delete all of the rows, but perhaps a certain set (say base...

Yes, it does appear to have been discussed frequently. However, I'm not 100% on if I need to create the function or not. From reading the suggestion in the link below it sounds like I need to define, or initialize, UserStatus before I can call it in the Transformer. Would I do that in a InterProcess...