Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have to transform a column schema into a postional row to insert it in a db table.
But i cannot find a component (like the tFileOutputPositional) who is not making a file
For the moment the best thing i found :
Is there any component with the tFileOutputPositional options to configure a positional line from an inpunt schema ?
thx for help
hello,
in tFileOutputPositional you have a schema defined , yes ? you can define therre the size for each column
copy that schema and use it in tFileinputpositional
Sorry for my confused explanation,
My input is delimited= "name;surname"
What i need is a positional structure to insert in a DB like that = "name surname "
hello,
in tFileOutputPositional you have a schema defined , yes ? you can define therre the size for each column
copy that schema and use it in tFileinputpositional
Hi uzix, thx for helping.
My objective is to not use file
In fact my input is a JSONB from a database and i have to transform it in a Positional structure and insert it in a VARCHAR column.
This is currently working with a temporary positional file (tFileOutput) structure but i'm looking for a way without using a tFile.
you can do it via java,for instance
System.out.printf("%s %s", "name", "surname");
Thx for the idea but i prefer to keep the tFileOutputPositional step with the userFriendly setting table for every column of the schema, because the schema is heavy (200 columns).
I was looking for the same component without making a file like an hypothetic "tPositionalRow" or "tOracleOutputPositional"