DSXchange

I disagree with the information regarding the usefulness of the PUT () function. I think that you can get useful debugging information with put by invoking similar to the following. =VALID(PUT("FTP", "adapter commands", data), LASTERRORCODE() + LASTERRORMSG()) RUN() returns a ret...

I am calling a child map using the RUN command from map rule. as below. =VALID(Run("LogoMap.mmc", HANDLEIN(1,(C[77]:.:In1+C[78]:.:In1)+ " -OE1")), "000") The child map is doing the correct Lookup and returning the correct value which i can see in the debugger tool ( I ...

Sorry, but invalid data and ABSENCE/PRESENCE of data are not the same thing. For example, in a type tree for a fixed length record (i.e..copybook...etc) , a text field can be padded with spaces, the range can be 1:1 and as long as the field at least has spaces (Pad Character) then it resolves the re...

I have a date field marked as optional. In the trace TX sees at offset 383 that the field failed the item presentation and that's OK. However, the next TX validation starts at the SAME offset 383 and fails. Somehow TX has to move 8 bytes forward to offset 391 doesn't it ? I'm new at this, what am I...

I have a date field marked as optional. In the trace TX sees at offset 383 that the field failed the item presentation and that's OK. However, the next TX validation starts at the SAME offset 383 and fails. Somehow TX has to move 8 bytes forward to offset 391 doesn't it ? I'm new at this, what am I...

Actually, why not use the UNPACK() function in a map rule to convert the data. I am not sure what the other person is talking aboutbut is does not seem to be TX.

Hi, I created a map with one input and one output card.Source for input card is File and target for Output card is Database.I already created xx.mdq file to generate type tree for my target table.when i tried to build the map iam getting following error "M1013 ERROR: Could not retrieve databas...

I was thinking that you could change the table description in Oracle to make it CHAR for the one column and create the type tree. Then change the table description back to CLOB in oracle and edit the type tree to the have the properties that you want for that column.

I was using an Oracle 9i DB at the time. I am not a DBA. But I do know that the database interface designer looks at some system tables in oracle when creating these type trees. You could always modify the type tree after it is created to include the CLOB. My $.02

Hi , Iam new to Tx .Here is the scenario i was trying accomplish.My Target is Database.I was using Database Interface Designer to generate type tree from Table.One of the Tables has "CLOB" as datatype .Database Interface Designer is complaning "Definition Table XXXX could not be acce...