MVSFORUMS.com

I believe sysibm.syscolumns table has this information. Look at the column named "NULLS". If it is "Y" then the column is nullable; otherwise not.

I used the below approach once for a similar problem:

Lets say you want to generate 25 random numbers (from 101 to 125). Declare an array of size 25 and value each element from 101 to 125. Now all ...

As you know, (-5)**1 gives you a negative number as the result. But (-5)**2 gives you a positive number. In general, negative number raised to the power of odd number will give a negative number as t ...

Craig, while I understand your comment about changing the original program I could see some reason as why the original program should not be changed - one of the reasons could be that its a common pro ...

Mouli,

I feel you can get the current date inside the pgm itself than resorting to tougher methods.

Vivek, One good point in passing the date thru parm instead of getting in the program is ...

Your job scheduler will have variables that gives the current day,month, year etc. Consult the manual to get those variables and pass them in the PARM.

IBM HATS (Host Access Transformation Solution, I think) can display CICS maps in web browser. You can search about this HATS in IBM website (www.ibm.com) for more information.

Have you seen the XML PARSE command of COBOL? I guess thats what you are looking for when you say "process the XML data file thru COBOL code".

To make it clear, the "XML format" as mentioned in your post is nothing but a text file having data surrounded by XML tags. Its not a different 'format' like ASCII or EBCDIC. You can open th ...

Never used XML GENERATE from COBOL. But we had as similar requirement to generate XML files from a flat file. We used XMLGEN from Fileaid and used the data file and a layout file as inputs to generate ...

You can try the following couple of suggestions:

1. If the IN clause values are always going to be sequential as given in your example (IPC1 thru IPC3 or IPC1 thru IPC5) then replace the IN clause ...

Viswanathan, your query would result in duplicates. If there are 2 rows with same id, the poster want to combine them into a single row. But the join you have would give 4 rows (2 * 2).

For trailing spaces, use FUNCTION REVERSE with INSPECT LEADING.

You may want to do this:

1. Use INSPECT command with TALLYING FOR LEADING / TRAILING SPACES option to get the starting and ending positions of your actual input. For example if your input is coming ...

Dynamic SQL's are usually cached by the database to optimize the performance. When the same query is executed many times the access path that is already determined wil be reused. Note that DB2 just ne ...