Originally posted by: ravi216

Hi,
I am new to WTX.I am working on a task I have an input flat file containing message "BECS123345 P 767". My task is i need to validate the input if it is invalid ,route it to one Queue.If message is valid then check for position 10 if it is
'P' route it to production queue
'T' route it to Test queue
'D' route it to Development queue

if it was unable to find or not valid then write it to different queue .

Can any one give any idea how to do this please....
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: NancyR

It depends on the structure of your type tree but you should be able to use either the CONTAINSERRORS or REJECT functions to determine if your file contains data errors. Then use IF logic to interrogate position 10 to see if you should send valid data to the production, test, development or error queue.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: gvh216

Hi Nancy i tried this problem i am able to do it by using IF condition and using PUT("MQS","-QMN QMGR6 -QN Production",INPUTDATA).

I am able to do it by using Queue name directly. I want to know one thing, can i get target Queue name dynamically from any other

input file, please let me know ... thank you so much for all your help i have been through some of your solutions those are so good..
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: paul.brett

Sure you can:

=PUT("MQS","-QMN QMGR6 -QN "+INPUTQUEUE,INPUTDATA)

(If the queue name is held in a file and read in by a card named INPUTQUEUE)

or

PUT("MQS","-QMN QMGR6 -QN "+GET("FILE","InputQueue.txt"),INPUTDATA)

(If the queue name is held in a file and you read it with a GET function)
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: gvh216

Hi Paul

I tried these two what you have mentioned .Map was getting successfully completed but i am not getting anything to my QUEUE. In trace it was showing nothing..
(Level 0: Offset 0, len 7, comp 1 of 0, #1, DI 000000000001:)
Data at offset 0 ('Helloo') was found to be of TYPE
X'0002' (blob1 Root).

INPUT 1 was valid.

End of Validation messages for INPUT CARD 1.

(Level 0: Offset 0, len 6, comp 1 of 0, #1, DI 000000000001:)
Data at offset 0 ('Prod<CR><LF>') was found to be of TYPE
X'0002' (blob1 Root).

INPUT 2 was valid.

End of Validation messages for INPUT CARD 2.

12:15:32.75 Jan 03 2012
(Offset 0: Map Number 0 (mapa1), DI 000000000000:)
Building TYPE X'0002' (blob1 Root).

12:15:32.75 Jan 03 2012
(Offset 0: Map Number 0 (mapa1), DI 000000000000:)
The rule for TYPE X'0002' (blob1 Root) evaluated to NONE.

OUTPUT 1 was built successfully.

End of Mapping messages for OUTPUT CARD 1.
End of Execution messages.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: NancyR

It looks like your map is not creating any data. It might be helpful if you posted your project interchange (and say what version of WTX it was created with).
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: gvh216

Hi Nancy,

I am posting my project interchange.

In map1 I am using GET function to read destination Queue

In map2 I am getting destination Queue from destination Card.

Can you help me with this. Thank you so much..
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: NancyR

The problem is in your input file dest.txt. Remove the second and third lines of that file. Your queue name is Prod.Queue+<CR><LF+<CR><LF>. You can see this by running the adapter trace. Just add the -T flag to your command string: =IF(LEFT(Inputcard2,4)="BECS",PUT("MQS","-QMN MB7QMGR -QN "+Destination + " -T",Inputcard2),"failed")
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: gvh216

Thank you so much it worked ,its really great site getting help like this....
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender