DSXchange

This is very handy, thanks for posting, Ray. I can see a a few adjunct uses for code like this, namely detecting en masse which jobs override project-level settings.

I think it is answered above....the ISDAdmin command. Today I started to transition all our Web Services enabled jobs to Parameter Sets for database credentials. That Parameter Sets are exploded to individual parameters in ISD, further with no awareness of Value Files, is an indication that better ...

The recompilation required behavior continues through 9.1 Fix Pack 1. Given the versions this issue now spans, it's hard to believe it isn't by design. The environment variable workaround works but is clumsy, as replication of variables inside Parameter Sets must occur. Our workaround is also clumsy...

I thought it worth noting that, in a 9.1 Linux installation, DSParams is the sole arbiter of User Defined project environment variables. Here's the test I performed: Open DSParams in a text editor Following format conventions, add a variable to the [EnvVarDefns] section Following format conventions,...

Many thanks to Phil for the table. I'm performing manual migration from 8.5 to 9.1, and this will come in handy for automating that process. Why not use the Migration Tool? We're moving from DB2 on Linux to SQL Server for the Metadata repository. Alas, I noticed the encryption scheme changed for 9.1...

Thanks, Craig, I didn't know about the UltraEdit option. I tried the link I found in this thread , but it is dead. I checked it out via the first Google hit for "datastage basic ultraedit" -- http://www.ultraedit.com/files/wf/datastagebasic.uew It's a workable solution, but I found it lack...

Thanks! I did see the syntax highlighter for Text Pad as well. I prefer Notepad++, so it's good to have options.

I posted this announcement to my InfoSphere groups on LinkedIn, but thought it might help to post here as well. ----- Our team works with DataStage BASIC every day. I use syntax highlighting cues to quickly analyze code, and miss that a lot when working with the DataStage Designer BASIC editor. To b...

devnull - Thanks for your work on this. I checked the project site on SourceForge and see no downloads available. Did you end up removing the code from SF?

I ran across the same issue, and tried conversion in a Transformer using UStringToString to no avail. I then realized that column metadata captured in my source data had the column in question declared as VarChar(10) non-Unicode. Adding Unicode to the Extended Properties for the offending column fix...

Thanks very much, Craig! Understood on support. I'm just starting to dig in, and this looks to be a nicely polished set of utilities. At minimum, I'll be able to glean some very useful information from it. Thanks again, and good luck on your ksh port!

PM sent, thanks!

I appreciate your looking, and completely understand about not being able to share the augmented version. I got a basic proof of concept working over the weekend. I'm still trying to get my head around the best way to handle job dependencies though.

Thanks for your prompt reply. I registered at Ken's site only to receive a PHP error message. Things look pretty dead over there. I found a contact email to which I sent a request for help, but I'm not holding my breath on a response. I hate to reinvent the wheel on Job Control stuff, but things are...

Hello all, I'm a pretty new DS user, but have many years coming in OO web / database development. After discovering our morass of Job Control code, I've been seeking out ways to consolidate and clean it up. I've seen many mentions of "KBA Job Control Utilities", which seems very interestin...