DSXchange

Ray, I found out this came from the advanced ee class. The zip for the whole thing including some make files and other stuff is called: "Extending DSEE.zip". IBM probably wants you to take the class to get the material but those in good stead with their Datastage support/sales person can p...

Wanted to add one more thing to make this complete. IBM has published a documement "Extending DSEE +Wrapper.ppt" that has a brief section on c++ functions in it. The examples of how to code fields for the Routine in Datastage show what needs to be done from the Datastage side and is very g...

Just to let people know there is hope. I have been using Hawk/8.x recently and though it seems slightly slower in the gui operation than 7.x it seems much more stable in terms of disconnects. I have had it sit 4 or 5 hours and came back to Datastage and it worked. That never happened on 7.x. My netw...

Ray, You must have run into that password thing before. What am I thinking of? There was definitely some password that Datastage <=7.x didn't like being more than 8 characters. Maybe I'm thinking of Oracle passwords. I know there were some characters in Oracle passwords that weren't allowed by Datas...

Hi, Shot in the dark but I have seen this happen many times. Datastage can only accept an 8 digit password. Unix will accept greater than an 8 digit password. Your putty sessions are gold but you can't login with Datastage. You have to change the password to 8 characters or less. ... Flash

Hi, I figured this out myself. The problem was the "Library path:" field in the routine. "path" suggests to me they just want a directory name and then they are going to look for the "External subroutine name:" in the "Library path:". The IBM documentation cle...

Hi, Just running a test routine to see if I can get C++ routines working on our Hawk install. Does anyone have a Sun c++ sample routine that works? this was the c++ routine: #include "string.h" #include "stdio.h" #include "stdlib.h" // declares this as a integer routine...

Hi, Tell the mainframe person to convert the vsam file to sequential. If everything in the file converts cleanly to a number or a letter you have the option of having your file transmission mechanism convert the file to ascii. If you are reading this file with cff stage you specify ascii. You can st...

Hi, arndt is a stud so I'll defer to him. But I will say in our organization that if you have completely different record formats (cff stage can definitely handle small redefines) in the input (an a in column 1 means header record - format x, a b in column 1 means detail - format y) we split them ou...

Hi, arndt is a stud so I'll defer to him. But I will say in our organization that if you have completely different record formats (cff stage can definitely handle small redefines) in the input (an a in column 1 means header record - format x, a b in column 1 means detail - format y) we split them ou...

John,

I was looking at this today. On Unix you can use DRS stage and select MS SQL Server as the database. Probably just doing odbc anyway, right? I haven't used Datastage for windows for a long time so I was curious.

... Tom

One presumes both your database and you Datastage server are windows servers. On the datastage server go into Administrative tools as admin then Data Sources and point to the Database on the other server with "Add" a data source. Then you should be able to reference the remote database thr...

I would argue that cff stage will translate all "normal" characters numbers, letters, special characters and not much else. You seem to be able to isolate the characters that are not translating. You may know about od -x against small ebcdic files that are residing on unix to see what you ...

I would argue that cff stage will translate all "normal" characters numbers, letters, special characters and not much else. You seem to be able to isolate the characters that are not translating. You may know about od -x against small ebcdic files that are residing on unix to see what you ...

Kenneth, You were right that there were other ways to call sql from bci. We had this working, it was compact and did what we wanted it to do, and we had bci before and after coded in 200+ ds jobs, so we struggled to find a way to make that investment pay off. We'll probably be doing your approach no...