DSXchange

Could you explain this in greater detail. I've been trying to make it work but I can't ever get my column name values to appear after the pivot.

I discovered that I was close in the my previous post. Since I'm doing the transformation in a transformer there isn't a need to use OCONV because at that point everything this still internal to datastage. Here's the finish routine I wrote to handle my situation: If Len(Arg1) = 8 And Iconv(Arg1,&quo...

So I just wanted to post the workaround I found for my problem. I never found a way to dynamically change the ODBC configuration. So the workaround I came up with was to configure a ODBC to point to an empty folder, then I execute several linux commands through the command stage to create symbolic l...

I tried going that route to have my database do the conversion but there were issues of data length limitations plus I felt as if there should be a pure datastage solution because I may not always be reading from a database. So I did some research and wrote a routine that I can us in my transformer....

I was victim of this same situation and this is how I was able to solve it. I thought it was worth posting in case anyone else comes stumbling across this thread. I hope in the future DataStage will build in functionality into killing processes for when this happens because in enterprise application...

Does anyone know how to take text and encode to base 64?

My data is xml text stored as a blob in the database. Then I'm pushing this into a web service.

Found this:

http://publib.boulder.ibm.com/infocente ... layer.html

Much more informative than lstsaur post

Does anyone have any good resources explaining/demonstrating the web services client stage? Want I'm working on is being able to transfer XML data (either a file or from the DataStage XML stages) to an outside SOAP service and I thought this might a good opportunity to see if DataStage could accompl...

Here's a thought that I just came up with, what about using the Dynamic-RDBMS stage? What I'm thinking is defining an entry in my odbc.ini file an entry like this: [MyAwesomeODBC] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf24.so Description=DataDirect 6.0 dBASEFile(*.dbf) CreateT...

It is a Unix environment. And you're right that when I statically define a DSN I'm making an entry in the odbc.ini file. The purpose behind all of this is I have multiple data files in many folders, so instead of making a bunch of entries in my odbc.ini file I would like to parameterize the DSN conn...

How do I execute a Unix command from within a UserVariable stage? And the unix command I would call, is it just a combination of the ls command?

Does anyone know how to code a dynamic DSN or if it's even possible for an ODBC connection? So currently each time I have a DSN I have to statically define it(driver location, database location, etc...) before I can use it as an ODBC connection. What I'm hoping to do it write a routine that I can us...

Here's my latest challenge, scan a folder and make a list of the files for a particular file type. For example a make a list of all the *.dbf files in a particular folder. Because once I have that list I'm going to loop through and make an ODBC connection to that file and extract the data that I wan...

I found a solution, adapting from mhester's post at viewtopic.php?t=91564 to write a routine that would return a 1x1 value. I can run my routine from just about anywhere; passing as a job parameter, user variable stage, etc...

Where there's a will, there's a way!

Can anyone show me how I can use an ODBC connection to select a 1x1 value into a variable/parameter so I can then use that in a WHERE statement on a different ODBC connection in the same job?