DSXchange

chulett wrote:I'm assuming A-F are being considered as hex values and thus valid in the Integer data type?

No, they are stripped out. If you want them to be interpreted as hex, then you should specify this in c_format %x.

Dan

Does anyone know of a way to have stronger data format checking when reading through a Flat File Stage, so that the above examples would be detected as errors? Thanks in advance, Wim Hi, if you use decimal instead of integer, (decimal[10,0]) it will work. Looks like the issue is coming from the fac...

I have found this reading some Ascential documentation: Transformer constraints are FASTER than Filter stage! Filter constraints are interpreted Is it true? I have always tryed to avoid transformers and using filter stages instead, but now it seems that transformer is better! Yes, at least for 7.5....

Can anyone please send me the commands that are used to check the Datasets in the Unix database. Thnaks in Advance You may use orchadmin. Run it without any params to get the help. Also, dsrecords it will give you the total number of records in the .ds file. Do not forget to set the APT_CONFIG_FILE...

Hi laxman.ds,
between the ODBC and your reject target add a modify stage and write into spec sqlcode=sqlcode. Be sure that you have the sqlcode column in the output.
It should work.

Dan

can you post the design of the reject capture ?

laxman.ds wrote:Hi!
XfmReject: Error when checking operator: Could not find input field "sqlcode"

Hi, you may use 2 successive "column importer" stages: - read the file as a single (long) line - varchar - the first one has as delimiter the ';' char, and the second group is imported as one single column - the second one it will have '~' as delimiter, using as input column the second gro...

What about setting the option Output Reject Records to true? Here is the link with the solution to your issue: (Vincent's blog) [http://wiki.ittoolbox.com/index.php/Parallel_job:_Retrieve_sql_codes_on_a_failed_upsert.] This is not a bright option since i have 7,8 foriegn keys in my table.is there an...

Insert a copy stage between the 2 modify operators. It will work. (!) there is also a configuration parameter (which I don't remember now - I don't have access to a DS) that may be set and it will do this for you: insert a copy between 2 modify operators. "modify" operator cannot have modi...

It wouldn't fit. Make the size double in DB2 (80 for this situation) if you insert data, or define it as 40 NChar / 80 char + unicode if you read data. UTF-8 should be enough. yes i checked both the sides the metadata is same. like character 40 on both sides. But i am not sure if on mainframe charac...

Hi, I have the value of input column as 99.99 whose metadata type is Decimal(5,3),this is further divided by 100 in the transformer stage and the output is coming as 1.0, the datatype in output is same as Decimal(5,3).But I require the value to be 0.999 and not as 1.0 without rounding off.Is there ...

hi, ... I have given decimal(38,10) as precision and sclae in both input and ouput columns of modify stage for the column QT. hi, you should specify the conversion QT:decimal[38,10]=QT == since you're not doing any conversion, this is a wrong answer == please ignore it == i cannot delete the post dan

JoshGeorge wrote:Set APT_IMPORT_PATTERN_USES_FILESET to True and try. If this didn't work you might have to get a patch from IBM for fixing this issue. Been discussed this before here.

Thanks,
I've seen the post. Looks like I have to go for that patch ...

regards and thanks,
Dan

Hi, I wonder if anyone got this strange behavior: I'm reading the files using the File Pattern as Read Method and File Name column in order to get the file name. It reads all the files correctly (about 500 in the original job - 5 in this example), but in the file name column I got only one file name...

Do not forget to set-up the environment variable APT_CONFIG_FILE before running the orchadmin.