DSXchange

I'm preparing to migrate from v9 to v11 and I've gone through the install process and can use the multi manager to switch between the two environments in designer. I'm now in Information Server Manager and I'm trying to Integrate Source Control but the option is grayed out for me in v11??? I had it ...

I know this is an old thread and you probably already got it figured out but I'm stumbling along the same path. I just found this link that I noticed that you need to single-quote the replace command http://www-01.ibm.com/support/knowledgecenter/SSPT3X_2.1.2/com.ibm.swg.im.iis.iisinfsv.assetint.doc/...

Can anyone tell me how to upload a file through a web service? There's not thing special about the file, it could be a csv, an image, or whatever. The web service is just a glorified FTP that I should be able to upload any file to. This is what I've started with: Folder Stage ---> Transformer ---> W...

When sending an XML Output stage document to a web services stage, on the other end the input message is being received as HTML Encoded. I'm guessing if my input message wasn't an XML doc then it wouldn't HTML encode it. In my web service client the input message column is defined as SQL Datatype: V...

I too am interested in this thread. I'm in the process of setting up the same framework. These are just my ideas so far as I'm preparing to roll this out for the team. Obviously have a Dev and Test branches created off of the trunk which is the prod. Disable developers from logging into the prod env...

So this might be a stupid question, but I'm checking out the new Oracle Connector after a datstage stage version upgrade. In the old Oracle OCI stage you could chose generate SQL and also specify a WHERE clause. This new oracle stage doesn't seem to have the same functionality?!? There's a lot that ...

I don't have a solution but your post peeked my interest. I too use CyberArk. And CyberArk has the ability to integrate into many applications that when it changes in CyberArk, CyberArk will update the applications as well. Are you trying to have CyberArk update parameter sets values? If so that wou...

If you're writing a routine to query tables to get their volume data information, why not just write a server job and use the database stages to execute the custom query and then send the rows to an audit table or whatever? You can write a generic server job that you pass in all the parameters you'd...

I've inherited a project where the original author loved hash files and would reference the same hash files across many jobs. Is there a way I can find all the jobs that reference a hash file by name?

Found the answer:

viewtopic.php?t=91285&sid=b6ac784102376 ... 914e68fb5d

So the code for test1 looks like this:

How do you reference a custom routine within another custom routine?

test2 test1 I would expect the result to be '2' but I get a:

I think I'm getting a little closer, I've modified my routine a bit to included these lines: $INCLUDE UNIVERSE.INCLUDE ODBC.H **this line was already there** DEFFUN DSAttachODBCDriver(hdbc) **added this line** RSTATUS = SQLConnect(hdbc,DSN,UID,PWD) **this line was already there** RSTATUS = DSAttachO...

I have written a custom routine that uses the ODBC driver. Everything in the routine works fine and I can get my results back. The issue I'm having is the routine throws this warning: [IBM(DataDirect OEM)][ODBC Oracle driver]The DataDirect product you are attempting to access has been provided to yo...

Datastage isn't behaving how I thought it would. [Source] Oracle date column which has the ability to also have a time component on it. In datastage this is defined as a timestamp to preserve the time. [Destination 1] CSV file. Columns specified as a varchar(10). In the transformer I do a LEFT(OCONV...

Can anyone explain how to do a vertical pivot for the server addition? All my searches are turning up example for the parallel edition. I'm assuming the pivot stage can do horizontal and vertical. I've used it for horizontal pivoting, so I've been testing putting different values in the derivation o...