Mainframes : Submitting a job from windows Command prompt

Hi All,

Here is a simple way to submit a job from command prompt .

1.  Write a job in a text file
2.  Enter FTP  <Mainframes IP address>
3.  Enter username and Password
4.  FTP> ASCII
5.  FTP> quote site filetype=JES
6.  FTP> PUT "Textfilehavingjob"
7.  FTP> QUIT

Done :)..  Your job will get submit,check spool .




Thanks!!

Mainframes - Db2 : How to know the PLAN for a particular transaction!!!

Hi All,

Here is a simple CICS command to know the Plan of any transaction under CICS.

CEMT I DB2TRAN TR(<transaction-name>.)

This will give you the plan name in the output.

WAMP-MY SQL : set language for error message.

The default language for SQL errors in WAMP 2.5 is French. To change it follow the instructions below.

Goto WAMP menu > MySql > my.ini

change the value of lc_messages to en_US

# Change your locale here !
lc-messages=fr_FR

# Change your locale here !
lc-messages=en_US


Hope it helps :)

Oracle Sequences - How to know next number in the sequence

To get the details about a sequence in Oracle, the table is user_sequences. We can query this table to get the next number in the sequence.

SELECT last_number FROM user_sequences
WHERE sequence_name = 'SEQUENCE NAME';

last_number column holds the next number in the sequence. The sequence name is the sequence for which you want to know the next number.

Note : The sequence number in the above query must be in upper case.

You can get more information like minimum/maximum value, cache size etc from user_sequences table.

SQL> desc user_sequences;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SEQUENCE_NAME                             NOT NULL VARCHAR2(30)
 MIN_VALUE                                          NUMBER
 MAX_VALUE                                          NUMBER
 INCREMENT_BY                              NOT NULL NUMBER
 CYCLE_FLAG                                         VARCHAR2(1)
 ORDER_FLAG                                         VARCHAR2(1)
 CACHE_SIZE                                NOT NULL NUMBER
 LAST_NUMBER                               NOT NULL NUMBER