DSXchange

Hi all, We are on linux, DS v11.3. We went through the process of setting up the files which needed to be copied over to the DS directories. We also hit limitations with the Security protocol, so had to create a replica of the required data and then use TM1 level 1 Authentication to be able to conne...

Hi all, Looking for a way to call RUNSTATS from DS v8.1 on DB2 v9.1.5. Looking for some help in calling the DSNUTILS SP. There doesn't seem to a lot of information around on how to do this other than the standard IBM doc. We have a DataStage application which loads data into the Target Tables. At th...

Hi all. This has been resolved. A college of mine provided the simple answer. If you look at the actual connector properties window. There is a diagram at the top left corner, which shows the link and the connector. When you click on properties for the stage it defaults to the link view, BUT if you ...

Hi Kieth Just to clarify we are on 8.1 and have installed the new DB2 connector which is not the old DB2 API. This connector allows parallel capability without all the setup and limitation of the DB2 Entrpse Stage.. Now, I've had the DBA change the Tablespace locksize=ROW which I would have thought ...

Hi all, Getting frustrated and looking for a different approach. Scenario. I have a job which has 2 DB2 Connector DB2 CONN (1) ----> CP Stage -----> DB2 CONN (2) DB2 CONN (1) Selects from Table X and Generates a new Sequence Number from the database for each missing Code / KEY pair. Cp Stage -- Uses...

Hi all. Any help would be appreciated. I have the following scenario. Surrogate_Key_Stage requesting Sequence numbers from a DB2 DB residing on z/OS. I have the following properties set in the Surrogate Key Gen: Database Type = Db2 Database Name = #DBNAME# password = #PWSD# ServerName = #SERVERNAME#...

Hi Ray, SEF = Sequential File Stage Extraction from Unidata is via the UnidataStage. The stage is pretty simply it just allows for the multivalued Unidata Structure. Don't have any issues here. The SurrogateKeyGen is done using a Flat File on the file system. We initially used a call to a DB sequenc...

Hi all, Here is the situation we have a series of simplistic jobs which extract from Unidata and then load into Db2. This is more of a replication project than true complex ETL. Anyway we had a problem with the following errors appearing in jobs randomly. Well so I thought. Message:: SEFJobVariation...

Hi all, As I said in my last post I would separate out the Project data Loop. :D This works fine. So is anyone aware of issues with the End Loop stage connecting directly to a sequencer stage ? The only difference now is that the JobActivityStage returns "TRUE" to the sequencer, rather tha...

Hi all, Thanks for the Code tag hint. That should make my diagrams easy to understand. I'll try and show the entire sequence job here, but note, I don't jump out of a loop. My nested conditions decides whether I perform the loop or not. So if there's no data, skip the loop and get the next iteration...

Hi all, Looking for some advise here. I've searched the site and looked up countless documentation but there doesn't seem to be a lot on using Sequence Jobs. (Or the finer points of using sequence jobs ) I have multiple loops and several nested conditions. I'm having a problem where the sequence job...

Yep I've repeated this from the parallel post, just incase it doesn't get moved. Anyway here is the answer In the Server Job which generates the file set the Format Tab :: Default Null String " In the Paralle Job which read the file the have set Format Tab : Field Defaults : Null Field Value &q...

[quote="chulett"]:? Nick, you just repeated [b]everything[/b] from your existing post on this problem into a brand new thread. There's absolutely no need for shenanigans like that which just leads to confusion with d ...[/quote] Sorry Craig new to this site, comment on the other post was t...

Hi all, I'm just trying to figure our how to best handle null in the Sequential File stage. I have the following Jobs in this scenario. Server Job Unidata --> Transformer (Oconv(dates)) --> Sequential file Parallel Job Sequential File --> Transformer (various) --> Db2 table. In the serverjob I have ...

Hi guys, Sorry Ray don't have access to Premium content yet. (There's a lot of red tape to get through to get a few dollars for something useful in this place ) :( I can understand that the Sequential file doesn't have any types. Having empty strings in my file is fine, I have made the columns nulla...