Search results for query: *

carp - I received this message when I tried " SQL0440N No authorized routine named "CONCAT" of type "FUNCTION " r937 - thanks, I was trying to avoid typing all the fields in repeatedly like this, but this maybe the only solution!

PHV, I actually truncated my actual query by putting in 2 values..I'll probably end up have > 50 so it may look like this: UPDATE PROD.PLM103_AXXS SET AD_ST = 'X' WHERE (PL_L_R, L_XD_SEQ) in ((12283952,1),(12283952,3),(1583952,1),(12583552,7)....) Your option would work if it was limited but...

Thanks LKBrwnDBA but it doesn't like the "||", I get this message now in DB2 v8.1: SQL0440N No authorized routine named "||" of type "FUNCTION

I am trying to run an update query which uses multiple parameters in the where clause updating multiple rows based on those parameters: UPDATE PROD.PLM103_AXXS SET AD_ST = 'X' WHERE (PL_L_R, L_XD_SEQ) in ((12283952,1),(12283952,3)) But it doesn't allow me to do so in SQL(DB2) giving me the...

We are in the process of converting from DB2 v7.2 to DB2 v8.2. We have visual basic 6.0 applications that use the datagrid ado control. In DB2 v7.2 datagrid works fine. In DB2 v8.2 the datagrid cannot find any results with BOF & EOF = True. Has anyone encountered this type of problem with using...

thanks all, the bean counter will be happy now!

wondering if in the pic clause there is something I can use to show parenthesis for a numeric value when negative: for example -123 would be (123) Thanks in advance

Is there a way to have 2 different font sizes on the same cobol report? I am using Microfocus NetExpress. Thanks in advance.

For the MCSD certification,is there any type of expiration to the certification?Say when a new version of say VB(ex.VB. Net) comes out does that mean your current MCSD certification is worthless? thanks

THANKS karluk ,it worked

is there any way in sql to search for a particular sequence of characters in a field regardless of position. For example the word "PAY" in field "OTPAY1234". Thanks in advance.

Go to http://www.aboutlegacycoding.com/, click on downloads, look for a program called sizer. It should do the trick.

Is there any way to find different fields length of input records? Ex. 7654321 would like to know it is 7 numeric character long 234 " " 3 " Thx

Does anyone know how it is possible to get a particular result in debug mode in Netexpress using Cobol, while if the same program is run standalone a different result occurs. thx

Just curious peoples opinions as to what programming languages are in demand currently? Thanks