Technology Questions

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

move_uploaded_file( string filename, string destination)

If you need to support random access, without inserting or removing elements from any place other than the end, then ArrayList offers the optimal collection. If, however, you need to frequently add and remove elements from the middle of the list and only access the list elements sequentially, then LinkedList offers the better implementation.

USING HOST VARIABLE we can pass data from COBOL to DB2

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

If constructor opens the file 

finalize() method closes that file.

If constructor opens the connection 

finalize() method closes that connection.

To perform finalization operation we must overriding finalize method.

Following guidelines to be following while writing Cobol program:

- Use ? EVALUATE ? statement for constructing cases.

- Use scope terminators for nesting.

- Use in-line Perform statement for writing ?do? constructions.

- Use Test Before and Test After in the Perform statement while writing Do-While statements.

The enter and PF keys transmit data from the screen; the PA keys tell CICS that a terminal action took place, but data is not transmitted.