My requirement is read contents of file, replace a string with a new string, store the result string in a variable. This variable has to be passed as an argument while calling HANA procedure. Is it possible to achieve this?
Text file will be placed in a shared folder, the file will have around 15K lines of text. As I said, it has to be read and replace function has to be executed on the content of the file. This result after replace function has to be stored in a variable, so that the variable can be passed as a parameter to the HANA procedure. Can you help me in designing, how the data flow has to be and I feel script will be required to work replacing string. If yes, can you help me in giving me an idea on entire flow.
Without knowing too much of your detail, I would recommend that you read the file, perform the transformation as you write the data into a table in HANA, then invoke a HANA procedure to read the contents of the table (because 15000 lines of text is not going to work for a scalar parameter in the HANA procedure).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.