DSXchange

Correct . But Im afraid my job wouldnt compile to get me that far - if it used a transform operator. We have a problem since our xlc compiler ( AIX) is a trial version and expired.

I could find a script named

cleanup_abandonded_locks.sh in my $ASBSERVER/bin directory.

I remember disabling NLS for TIME datatypes ( Under LOCALE, TIME/DATE -set to "OFF") for an entire project . Some of the 'out of the box' transforms using DateGeneric***** will not work the same way if migrated from an non NLS to NLS enabled environment.

Reset the sequence and see if you get any additional information during reset in the job log. Sometimes recompiling a sequence will simply solve your problem.

Does anybody have an idea of what operators are combined for the SCD stage ? Something tells me it uses a combination of lookup and transform operators , but it could also be change capture( with a possible interface to a Generator operator perhaps) . Does anybody have an in-depth understanding of t...

Marking this as resolved . Since I started using TFS in a rather crude fashion to check in documents test case worksheets and DSX files and associated scripts. We may switch to CVS later on - once we have corporate blessings .

Thanks for confirming my suspicions!.

Im now thinking , the fact that an Unix Wrapped stage requires the command to be 'pipe-safe' precludes any usage of it on a per row mode.

I do use a "spam generator" email job to send info messages to each office ( with a contact 'email list' thats vertically pivoted list of comma seperated email ids) if their records had a lookup failure - and I use exactly Ray's approach , but its a server job. For a pure parallel approach...

Thanks Ray. After reading your post ( but skipping over the documentation - which is bad practice, ) , I managed to install the TFS plugin into IIS Manager. I could also open the TFS perspective. Now I will need to look for a TFS id & URL - which can't happen until Next week . Until then..

Can you log on to Xmeta and run this Query? You post shows you are in version 8 or above :) select DSNameSpace_xmeta,moduleName_xmeta,SourceFlag_xmeta , sourceCode_xmeta , subtype_xmeta from xmeta.DataStageX_xmetagen_DSRoutineXXXXXXXX WHERE moduleName_xmeta = 'DSU.'.<YourRoutineName>and DSNameSpace_...

Can I use IBM Information Server manager with TFS for datastage version control/code management ? I see that TFS has an Eclipse plugin .

Im not sure how to link IBM IS Manager with Eclipse plug in for TFS.

Usually I call routines directly in a transformer. Since I began with v 4.1 ( Ardent datastage) around 2001 - I dont think I ever needed to call routines from a transform. :) For the OP's question , I think the routine could have been imported from another env without source code present . In such a...

You should have seen them thro' vi . The additional DOS character ( Carriage Return) will usually show up as ^M in vi. You may not be able to see it when you do "cat filename".

My favorite utility for control characters remains unix's "od"
od -c and od -x to be specific

If your file format is really that simple , why dont you use a Transformer and funnel stage ? You dont have to worry about iterations and loop variables. (& is the name of your input link) o/p link 1 : &Name , "CELL",&Cell.Number o/p link 2 : &Name , "WORK",&W...