DSXchange

... you'll find it <a href="viewtopic.php?t=106358">here</a>

Are you having trouble accessing the online help? Oconv(expression, conversion [@VM conversion] ...) expression is a string stored in internal format that you want to convert to an output format. If expression is a null value, null is returned. conversion is one or more conversion codes specifying h...

Amit_111, It's been said before but you can really help yourself alot by using <a href="http://www.dsxchange.com/search.php">search</a>. Searching for "Job Locked" gives 38 matches. <a href="http://www.dsxchange.com/viewtopic.php?t=99125">Here</a>'s a good one that will...

... or you can skip them in Unix using the 'tail' command as a filter on your sequential file stage:
HTH,
J.

Duplicate post.

(duplicate is <a href="viewtopic.php?p=229779">here</a>.)

sjordery,

The chances of having your question answered will not increase by posting it in multiple forums.

Have you tried the product documentation?

J.

LORE, Your NULL data is not meeting the fixed-width requirement of your QualityStage job. Use some tool to substitute the appropriate number of space characters for the missing values (NULLS.) You can achieve this using DataStage, a Unix shell script, or possibly in whatever tool you are employing t...

LORE, You rightly said that QualityStage requires data in Flat File format. If you are using DataStage to host your QualityStage job (using the QS-for-DS plugin) you can stream data directly from an ODBC stage into your QualityStage job. If you are not using DataStage (and wish/need to use QualitySt...

Hi Eulderma, We chose to use a format like 'DATASOURCE.Text Description'. E.g. ACCOUNTS.Mismatch to Meter_Grps ACCOUNTS.No live mandate for live DD ACCOUNTS.Billing suspension date not null AGREEMENTS.AGRMT_CUST_NAME is null AGREEMENTS.Invalid price for SME AGREEMENTS.No price line for CORPORATE etc...

You might also want to take a look at the FAQ here:
viewtopic.php?t=92038

J.

vivekreddy, Where are you looking for the environment variables? Try this: - In Job Properties Parameters tab click "Add Environment Variable" - Click 'New' (at the top) and create the variable USER, then select it from the list to add it to your job - In your job give the USER parameter t...

Hi vivekreddy ,

I'm on Unix so can't check this for you at the moment but I believe under Windows you should be able to use the environment variables NAME, USER, or USERNAME.

(For the record it's 'LOGNAME' under Unix)

HTH,
John.

DSguru2B, , We've got a number of jobs which work this way. I streamed a VarChar column containing Integers 0 to 100 into a transformed and had two output links with constraints: Link1 Constraint: Index (InputCol, '1', 1) & Link2 Constraint: Not( Index (InputCol, '1', 1) ) And got the correct re...

Thanks DSguru2B, Whilst we're on that point, wouldn't a constraint without the >0 work OK? I thought Booleans were expressed as zero for FALSE and non-zero for TRUE? So a positive Index match would be interpreted as TRUE and a Index non-match would equate to FALSE. Is that wrong? (I'm hoping this do...

Oh ... and if you want to use proper regular expressions in your transformer there's the C source code for a Parallel Routine to achieve this <a href="viewtopic.php?t=107882">here</a>.

HTH,
J.

Despite the help file documenting that you can use LIKE with regular expressions in Filter stages we've never managed to get it to work on 7.1r2

Wouldn't it be easier to do this in the Transformer?
Try using :
HTH,
J.