User bio
404 bio not found
Member since Jan 24, 2019
Posts:
Replies:
Im executing inside a sql procedure the next sentence:
Set columnLength = ""
&SQL(SELECT character_maximum_length INTO :columnLength
FROM information_schema.columns
WHERE table_name = 'MYTABLE'
AND column_name = 'MYCOLUMN'
AND table_schema = 'MYSCHEMA')
If ((SQLCODE = 0) && (columnLength '= 32000))
{
&SQL(ALTER TABLE MYTABLE ALTER COLUMN MYCOLUMN VARCHAR(32000))
IF ((SQLCODE '= 0) && (SQLCODE '= 100))
{
SET %sqlcontext.%SQLCODE = SQLCODE
SET %sqlcontext.%Message=%msg
Quit
}
}
And im getting the error:
%msg: <Insufficient Privilege For Operation at location: DDL ALTER TABLE Modify Column Datatype>]
And i try with NO Data and the same error.
I added a %All rol to my user connected and then it's possible to alter the table. So i need one permission or priviledge that im missing....
the result is true for this command, so i have access but doesnt work.
Certifications & Credly badges:
Javier has no Certifications & Credly badges yet.
Global Masters badges:





Followers:
Javier has no followers yet.
Following:
Javier has not followed anybody yet.
I don't know if i will prefer override the %JSONExportToString and %JSONExportToStream or wrapping but that dirty trick..