Converting VarBinary to VarChar
Hello,
I'm looking to find if there is a datatype convert equivalent in Object Script to SQL convert function. Have a VarBinary string coming in from source application (which is really performing a SQL dump). The source application uses the standard SQL convert function to convert from varchar to varbinary on their side.
I know &sql(Convert()) should work in Object Script, but am wondering if there is a better way of doing this.
Getting data in via flat file (Record Map), then using data transform to transpose this data to SDA3.
Does someone have a suggestion or know of a better method of doing this data type conversion in Ensemble? Or is &SQL() the only feasible option available.
Thank you
The CAST function has some examples that do not use embedded SQL: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
Thanks, Chris!
Thank you, Eduard!
ObjectScript method:
is equal to SQL Convert function.