get name column

[Anonymous]

hello
(sorry my english is not perfect........I still learning)
can I get the name of a some columns instead data in a tmap?
I need this name to find this in other table(validation table) and get the values max and min and compare (validate) the data of this field..
or...
how can I make a query in a function (in ROUTINES) with two parameters, to use this VAR space on a tmap, and this to return the MAX value or MIN value that I need?

regards

[Anonymous]

Hello

can I get the name of a some columns instead data in a tmap?

See the related 6441.

how can I make a query in a function (in ROUTINES) with two parameters, to use this VAR space on a tmap, and this to return the MAX value or MIN value that I need?

You don't need to use Var space,
assuming your job like: tFileInputDelimited--row1-->tMap--->tMysqlOutput, type in the following code in the expression field of output column:

RoutineName.methodName(row1.param1, row1.param2)

Feel free to post your questions on forum!
Best regards

shong

[Anonymous]

mucho thanks ...............
now I have another question............... how do I get the name, or reason of why it was rejected and save this, in a filed in my rejected table.......because there are a lot of fields, and I want to get the error field......
regards.....

[Anonymous]

Hi Shong,
What about column length. How to retrieve column length?
Thanks in advance.

[Anonymous]

Hi Shong,
What about column length. How to retrieve column length?
Thanks in advance.

Hi
Why would you like to retrieve the column length? Can you explain a bit for your request?
Shong