Update in SQL
I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. ...
I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. ...
285 pts.
There is a way to order one SQL union file?
I have to conect 2 files, the current and the historic. Both has the same structure but the fields names are diferent. This is the complete command but i can not order to put the records in a subfile in the order that i need: C/EXEC SQL ...
I have to conect 2 files, the current and the historic. Both has the same structure but the fields names are diferent. This is the complete command but i can not order to put the records in a subfile in the order that i need: C/EXEC SQL ...
Suffix a record using SQL
Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks
Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks
I can create a SQL procedure using i series navigator but do not have any authority on the procedure.
I can create a SQL procedure using i series navigator but do not have any authority on the procedure. When i view the procedure on i series navigatore it show that iam the Definer, however when i try to change the permissions on the procedure i get following message CPFA09C Not authorized to...
I can create a SQL procedure using i series navigator but do not have any authority on the procedure. When i view the procedure on i series navigatore it show that iam the Definer, however when i try to change the permissions on the procedure i get following message CPFA09C Not authorized to...
SQL/400 commands
Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto
Hi friends, How can I see or get the SQL/400 commands executed from another user ? Regards, Roberto
Journey from SQL/400 to SQL Server Development
I'm fairly comptent with SQL/400 , scripting, etc. - - how difficult would it be to applying this to learning something like "SQL Server" ?
I'm fairly comptent with SQL/400 , scripting, etc. - - how difficult would it be to applying this to learning something like "SQL Server" ?
