DSXchange

Environment :- Datastage 8.1 (Server Edition) With the use of "web service client" stage I am able to login into SFDC,and stored the server URL,session ID etc fields into a sequential stage. But I am not able to retrieve/Create data from/to SFDC(Sales force dot com). Questions:- 1)How can ...

Chulett,

Oracle version:10g
This version in Production is same as the other servers.

In the MQStage, Under Tab "Output", and in "Message Filtering Options", Check "Apply Filtering" and in the "Message Format" text box, you can add the type of messageformat eg.MQSTR or MQRFH2. This will enable the MQ stage to read XML messages of different mess...

Hello Experts, If you are looking to convert EBCDIC to ASCII for a type as Integer, I guess there are no properties available for Integer columns. So you may have to read data as Decimal with No Scale and then use a transformer stage to Map Decimal --> Integer. This worked for me, posting this here ...

Hello Experts, Can we read MQHRF2 message format MQ messages in Datastage? Currently the jobs are failing with a Fatal Message: "The WebSphere MQ plug-in is unable to process non-string formatted messages." Is there a patch/ admin variable that will enable DS to read the MQHRF2 messages? P...

Hello Experts, I have the following data definition COLUMN_A CHAR(3) COLUMN_B DECIMAL(15,2) I have the below Input Data 09000000000005678} I used Sequential Flat File Stage and set the following options only on the decimal column 1. Packed = no(overpunch) 2. Signposition = Trailing When i view the d...

Hi All,

Datastage has taken care of this. Nothing specific needs to be done used an ODBC stage in parallel mode.

Thanks,
Vijay

Dear all,

Is there a solution for this? How can we set the length and send it to the VARCHAR column and expect that it shouldnt be visible?

Please let me know.

Thanks,
Vijay

Hello Ray,

The LENGTH COMP field isnt visible at all unless someone has this DCLGEN. Is this internal to mainframe? Is there a possibility that we can send data into this complex structure using datastage(LEN+TXT)? LENGTH is COMP field and TXT is VARCHAR.

Please let me know.

Thanks,
Vijay

Dear All, I have the below DCLGEN in mainframe: 10 EOD-EDI-TXN-DTL-TXT. 49 EOD-EDI-TXN-DTL-TXT-LEN PIC S9(4) USAGE COMP. 49 EOD-EDI-TXN-DTL-TXT-TEXT PIC X(3900). I have a DB2 table that has a column EDI-TXN-DTL-TXT VARCHAR(3900). But this comprises of the above structure like an object. I am generat...

Hello Experts Is there a way i can generate Unique timestamps (yyyymmddhhmmss) for every record in a flow. Tried creating one using the Date and Time functions in the transformer as well as using a Sparse lookup (input volume is sub 10k rows) and running them in sequential. The generated timestamps ...

Forgot to tell you that the version of DS is 7.5.3, if it helps

Hi, I am at a cross road between choosing one of the 2 types of designs. Problem : From a database i will receive 6 different types of levels, Based on the level(eg: 010,050,030,060) i need to perform a. Split the String into multiple columns b. Perform validation of each of these columns and Add up...

Then you're going to have to find out where the truncation is occurring. For example, is there a SUBSTRINGS function in the extraction SQL? Is there some point in the job where the field is a VarChar(26)? DataStage will NOT exhibit this behaviour unless it is programmed to do so. Hi There is no sub...

ray.wurlod wrote:Do you have any good reason for using unbounded VarChar? If not, use VarChar(50) and you will guarantee sufficient storage for all characers in the string.

I have tried with VarChar(50) option. But still issue is same.