| Author |
Message
|
| rama_gadela |
 Posted: Wed Jul 07, 2010 3:13 pm Post subject: Retaining Input file in WMB |
 |
|
Newbie
Joined: 06 Jul 2010
Posts: 4
|
I have a CSV file & I need to validate it by using a WTX map (This part is working fine)and if there are no validation errors then put all the records in the file as messages on to the queue(This part is working individually).If there are errors then I shouldn't be putting the messages on to the que instead I should be rejecting the file (Should be abl to ftp the very input file back to the user).How do I retain the very input file so that I could ftp the bad file.
Thanks in advance |
|
| Back to top |
|
 |
| kimbert |
| Posted: Thu Jul 08, 2010 1:54 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| I have a CSV file & I need to validate it by using a WTX map |
That statement needs to be proved. The MRM TDS parser can parse CSV, and the usual recommendation is to use native WMB facilities where possible.
| Quote: |
| How do I retain the very input file so that I could ftp the bad file. |
Parse the entire file as BLOB initially. Save InputRoot.BLOB.BLOB into the environment. If the CSV processing fails, take the BLOB from the environment and send it back to the user. |
|
| Back to top |
|
|
| rama_gadela |
| Posted: Sat Jul 10, 2010 1:17 pm Post subject: |
|
|
Newbie
Joined: 06 Jul 2010
Posts: 4
|
I am new to the tool.Can you tell me how I can save the InputRoot.BLOB.BLOB into the environment.
If this can be done in the compute node I would request the syntax please.
Last edited by rama_gadela on Sat Jul 10, 2010 1:44 pm; edited 1 time in total |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sat Jul 10, 2010 1:30 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| rama_gadela wrote: |
I am new to the tool.Can you tell me how I can save the Save InputRoot.BLOB.BLOB into the environment.
If this can be done in th ecompute node I woulod request the syntax please. |
What have you tried?
Have you done a search on previous posts on this Forum?
The answer is there.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| Vitor |
| Posted: Sun Jul 11, 2010 4:17 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| smdavies99 wrote: |
| Have you done a search on previous posts on this Forum? |
Maybe, maybe not. He's certainly indefatigable in terms of posting as this is the 3rd attempt (this and this) but a little poor at answering follow-up questions.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
