Search results for query: *

I believe that your query should be like update t1 set t1.sqlcolumn = 'INSERT into t2 select case when t3.sqlcolumn in not null then t3.sqlcolumn else ''N/A'' end'; Its two consecutive single quotes and not double quotes. Cheers, Emmaar

I found that the system reads the values from a .properties file. Thank you very much for your efforts. Cheers, Ramkumar

Hi, I have the below line in my java code which returns HPS555P. System.getProperty("CICS.EYE.pdpCustDetailR.packageset"); I want to know from where it picks up this value and how I can amend it. Thanks and Regards, Ramkumar

SELECT LEEN_ID , TAXD_ORIG_START_DT , TAXD_TAX_YEAR , UPDATE_USERID FROM ANPDBAP.ANPT031...

Hello, Can anyone tell why the below sql failed. INSERT INTO UP2DBAP.TDB01R09 ("TIMESTAMP", TS_TDB01R09, POL_NO, CASE_NO, GRANTEE) VALUES (...

Thanks Jack. Can anyone tell me the syntax of DEADLINE in JES with an example. Ramkumar

Thanks for your replies. Ramkumar

Thanks for your immediate response. Is there any option available for OS/390 ?? Ramkumar

Hello, Is there any way to specify the start time for a job in JCL.?? Thanks in advance. Ramkumar

I believe that the table named TEMP is not physically created/stored when the program is run. Please correct me if my understanding is wrong. A person without any Tablespace allocated for his Id can run the above query in Production QMF. So I thought that the query above will work in Cobol...

Hello, Can I have a SQL like the one below in a COBOL-DB2 program. SELECT R25.ACCTG_PREM FROM UP1DBAP.TDB01R25 R25, (SELECT MAX(ST_ACTION_DATE) AS THFMAX FROM UP1DBAP.TD4101R1 WHERE SOL_TRANS_CONT_NO = :H-POL-NO...