Recent content by eyetry

lot of ways to do this.... try the function 'isnumber'

path\mercnt.exe path\map_name -if1 "path\file_name

you need to look at the DB trace file. It will give you a better, more relevant, return code.

are you using package() or seriestotext() in your email cmd? Sometimes seriestotext works where package doesn't.

Maybe this will help... GET("SHL","-cli -cmd 'script.sh arg1 arg2'") GET("SHL","-cli -cmd 'script.sh -ABC target_path/file '") Note the case for CLI and CMD are lower... Make sure you use them in lower tense. I understand that Unix is case sensitive and all examples I saw had them in...

Unstringing might work if you don't have to worry about a stray "MD" (or other delimiting value) impacting the process. definitely worth testing...

lack of terminators will make it challenging. Things that would help would be initiators, delimiters and fixed lengths. Even with those you may have issues. Where does segment end if it's defined as text and you can't define a way for the map to identify the end of data. Post fix delimiters...

I wish I could help you more. Unfortuantely we aren't using WTX in a unix environment... shot in the dark.... try changing 'SHL' to BAT and see what happens.

Have you tried using '-CL' or '-CLI' instead of '-CMD'?

is this on unix?

Probably need to see an example of your data. But, it looks like you have two record types. Or, do you have 4 record types 2 for child and 2 for grandchild? If the former what differentiates the child from the grandchild? How you would do this would depend on your type tree. 'Index' might...

Yes, the '-' means read from the right and 'number' is which delimited word you want.

This seems like a type tree problem. Make sure Field3 is required with min value 0.

Audit log is specific to a the map being run and is in an XML format. Trace files tend to relate more to adapters and are ASCII.

I would recommend one output per table.