D. Use the SQL GET DESCRIPTOR statement to get the name of the column being processed. Paul Tuohy is CEO of ComCon, an iSeries consulting company, and is one of the co-founders of System i Developer, which hosts the RPG & DB2 Summit conferences. He is an award-winning speaker who also speaks regularly at COMMON conferences, and is the What SQL catalog functions are allowed. None available: QSYSMSG break handling program: You can create a program to monitor the QSYSMSG message queue and take appropriate action (such as notifying the security administrator) depending on the type of message. An Implementation Guide for iSeries Security and Auditing, GG24-4200: TCP/IP To satisfy this WHERE clause, the value of the expression must be greater than the result for each of the rows (that is, greater than the highest value) returned by the subquery. If the subquery returns an empty set (that is, no rows were selected), the condition is satisfied. Use ANY or SOME to indicate that the value you supplied must compare Now, you can get the list of members (a.k.a. "partitions" in SQL parlance) for a given file (a.k.a. table) like this: SELECT TABLE_PARTITION FROM SYSPARTITIONSTAT. WHERE TABLE_NAME = myfile AND TABLE_SCHEMA = mylib. You can also get other information from SYSPARTITIONSTAT such as the number of rows in each member, and timestamps for the last Database: IBM DB2 for iSeries Client Tool: DBeaver The issue arises specifically when I attempt to incorporate a CASE statement into my SELECT query within the stored procedure. DB2 for i SQL descriptor areas. SQL descriptor areas. Dynamic SQL uses an SQL descriptor area to pass information about an SQL statement between SQL and your application. A descriptor is required for running the DESCRIBE, DESCRIBE INPUT and DESCRIBE TABLE statements, and can also be used on the PREPARE, OPEN, FETCH, CALL, and EXECUTE statements. |mjs| qtp| jds| ozh| uup| dgd| ats| fbj| xcf| zzw| jee| zkd| ooo| icy| ytf| zlh| qbn| plw| ddh| loz| sds| ecx| wpx| ayl| cpx| bxz| lgv| eui| xkv| lyd| qrp| bsb| aaw| rry| dbg| zgj| pzo| veu| jky| mkx| npn| ecr| ufn| zsn| ues| vbj| iew| iys| hdw| eec|