DSXchange

[quote="ray.wurlod"]Yes, in any form of UNIX (including Linux) the file name is /dev/null. It remains the case that you must append to it, not overwrite it.[/quote]

and that worked , thanks

[quote="ray.wurlod"]Not directly, but you can use a Sequential File stage to append to the file .\NUL (which exists in every folder). Tip: don't try to overwrite .\NUL - you have to append to it.[/quote] a little mistake (but i bet significant) in my starting post. This is in aLinux enviro...

Hi I have made a job that runs a stored procedure with the Stored Procedure Stage The return value from this stored procedure is being put in the UserStatusArea of the job, for later reference in a sequence. This is done in a transformer where i am calling a little routine writen in basic, that uses...

thanks craig

the dssetuserstatus suggestion is working beautifully

regards

Peter

Hi i will try to explain what i am after In our environment the writting into staging area tables, are to be partitioned (not Information server partitions) Meaning. i have table named 'StagingData' that i want to load a new days data into. A stored procedure has been created by the DBA that is to b...

Just to let others that browse for a solution to this:

this patch is now available

Connector Rollup Patch 1 from august 23rd 2009 solves this issue

there is a patch that solves this issue.

The 'Connectors Rollup Patch 1', from august 23rd 2009 solves this

regards

Peter

yeah, you are right i missed that part. i was strogling with the same error message as the post had in his first attempt, and was happy to see that i was not alone, and didnt read more thorough enough on the rest to see that he actually made a different attempt. i have tried my test sample in many d...

thanks for the tip, looks better now

Before shipping the complaint to IBM i gave it one more shot. After thorough look at the documentation and trying everything i could think of, i got the range lookup to behave as i wanted. in my case the solution was found in the lookup stage, constraints popup window, where there is an option to se...

I have tested our little sample program on a Windows environment, exactly the same error

(and in our sample all columns for both the range and the equality lookup is integers)

we will create a support issue today

regards

Peter Tilsted

[quote="narsingrp"] I was getting warning message as: Lookup_60,0: Ignoring duplicate entry; no further warnings will be issued for this table , Message ID : IIS-DSEE-TFKL-00055[/quote] hi. We are getting the exact same error i the project i am on. We are running version 8.1 on unix and li...

Hi

I did use the 'publish' functionality in Information Analyzer, i must have skipped some important part in the definitions, i'll try again from scratch.

regards

Peter
(passed the 000-418 test to day so is now certified Information Server developer)

Hi Vince thanks for your clarification (to me at least :-)) I did the follow the lifecycle you mention, and is only missing the third part to happen :-). I used the ODBC Connector, to a MS Sql Database. I am only investigating the possibilities with Information analyzer, to give a demonstration for ...

Hi when publishing the results from Information analyzer i get this sentense from the manual: "You might want to publish statistics and annotations for a table or column to provide developers in additional suite components, such as IBM InfoSphere DataStage or InfoSphere Business Glossary, acces...