DSXchange

I checked the situation again and the issue seems to be present only using the test option, at runtime it works fine.

I mark the post as resolved, sorry for the mistake.

Hi All, is there any limitation in length of Args for server routines? I am parsing a text field and if I do it inside a transformer I have no problem. Being the parse a bit complicated I wrote a server routine and everything works fine except that Arg1 is truncated at 1063 characters. I did an easy...

Hi All, I am using the following query against localuv in order to find all jobs that use a specific table: SELECT DS_JOBS.NAME , DS_JOBS.CATEGORY , DS_JOBOBJECTS.NAME , DS_JOBOBJECTS.OLETYPE , EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),upcase('#TableName#'),1) > 0 then 'FOUND' else ''" ...

Hi, I made the following test: 1) imported a sequence with a job into my project (design and executable). 2) run the query: select * from DS_JOBS where NAME='MYSEQNAME'; and I got the record related to my sequence (with id 4228). run the query: SELECT DS_JOBOBJECTS.OBJIDNO, DS_JOBOBJECTS.OBJID, DS_J...

Hi All, I'm facing an issue with a query on my repository through uv stages. I'm selecting some job attributes with a query on DS_JOBS and DS_JOBOBJECTS but I found some missing objects. Those missing objects were imported (design and executables) from another repository. I recompiled them and at th...

Hi trokosz,

The -q64 parameter indicates the compiler to run in 64bit mode. Was your system booted in 64bit mode? (bootinfo -K)

Regards,

Alessandro.

I All,

Is it possible to convert a two-bites ascii string to its equivalent hexadecimal value in a parallel trasformer?

Thanks,

Ale.

In the "Edit Row" for that column, under Properties | Nullable, add the Available properties to add: Null Field Value. Set the value to whatever that is the "exact length" as specified in the Length field. For instance, if Length=7, Scale = 2, set the value to 000000.00 (9 bytes...

Thanks for your suggestion ArndW, I didn't see it

Do you know how can I represent the null value?

Thanks a lot.

Ale.

Hi All, I have se following issue. I have to read an EBCDIC Binary file and I use a PxCFF stage. Actually I have a decimal field that could be empty (Low Value in host). If a low value is found in a decimal field the default value set in: Stage properties - Stage - Record Options - Default Values - ...

The problem was effettively linked to the 64bit objects linked to ds 8.1. On last friday (friday the 17th :) ) we migrated from version 8.0.1 to 8.1 and we restored into the new installation all the old environment variables set before the migration. The problem was that compiler options are slightl...

Hi ArndW, Compiler options are those you mentioned. If I execute this from command line: /usr/vacpp/bin/xlC_r -L/sw/IBM/InformationServer/Server/Projects/DATAWAREHOUSE_CEDACRI/RT_BP255.O/ -L/sw/IBM/InformationServer/Server/PXEngine/lib -L/sw/IBM/InformationServer/Server/PXEngine/user_lib -G -lorchai...

Hi All, I read a lot of things about this problem in the forum but I was not able to solve the problem by myself. This is the error I get (from the more button after an unsuccessful compilation): Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 10:25:16(000) <main_program> IBM We...

ray.wurlod wrote:Looping within the Transformer stage is "in the plan" for a future release, maybe even 8.2. ...

That's a good news , I hope it will come soon.

I think a big lack in datastage is the absence of a complete loop stage. Actually if I want to loop on the rows of i.e. a flat file, grab its column values and pass them to another job I must use UtilityRunJob routine in a transformer stage. However in this way I have to "drown" a job call...