Search found 109 matches

by Veera
Sat Jul 14, 2007 12:48 am
Forum: DFSORT , ICETOOL & Utilities
Topic: number of records in input file
Replies: 3
Views: 11475

This should work ...it will write the no of records to SORTOUT FILE , COUNT -> Is the keyword //SYSIN DD * SORT FIELDS=COPY OUTFIL REMOVECC,NODETAIL, TRAILER1=(10:'NO OF RECORDS:',COUNT) /* Thanks, Veera.
by Veera
Sun Apr 22, 2007 5:33 am
Forum: COBOL
Topic: SAR reports
Replies: 5
Views: 10929

Sumitra ,

What settings info are you exactly looking for,

any report parameters ???

well you can post your exact query ...there might be few who worked on it...

some one will get back to ur query...

Thanks,
Veera.
by Veera
Sat Apr 21, 2007 4:35 am
Forum: JOB DISCUSSION
Topic: Reg my Job search
Replies: 3
Views: 13641

Gopal, What i wud suggest is 8/9 months is very less to be considered as experience , but then if you definitely wanted to change you can go ahead or else you can wait for couple of more months and then you can look for the opportunities. once u have 1 + exp u have good possibility of jobs and propo...
by Veera
Fri Apr 20, 2007 10:22 pm
Forum: JCL
Topic: EDIT a STRING
Replies: 7
Views: 12037

mantorras2006, Where and how is this file being generated in your system. If this particular file is being read as I/P for some programs or O/P for programs then there should be some way of identifying each record and then it processes it. well If this file is not generated by the system then one ha...
by Veera
Fri Apr 20, 2007 10:03 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Locking Heirarcy and Compatibility?
Replies: 1
Views: 5328

Its answered in your other post, better to maintain single thread for the same topic.

[url]

http://www.ibmmainframeguru.com/Mainfra ... php?t=2425



Thanks,
Veera.
by Veera
Fri Apr 20, 2007 9:48 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Various Locking mechanism for cursors and other SQL?
Replies: 3
Views: 11209

LOCK TABLE statement locks all tables in the table space. Highest Priority This command should be used with utmost caution depending on ur Batch Vs Online trails, Because when the command is used it will also prevent the online users from any Updations. The Lock is held until COMMIT or DEAL LOCATION...
by Veera
Fri Apr 20, 2007 8:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Finding PLAN(or Package)
Replies: 6
Views: 13194

Yeah Krishna, acevedo that would be great.

As info:

I have also posted one thread in General Discussion

How important is Feedback in Techincal Sites.

Thanks,
Veera.
by Veera
Fri Apr 20, 2007 7:10 am
Forum: General Discussion
Topic: How important is Feedback in Techincal Sites.
Replies: 4
Views: 6015

How important is Feedback in Techincal Sites.

Folks I was just thinking about it for a while ..so thought its a good idea to start a thread where everyone can share there views , i will be glad to hear from all. Feedback is an essential element irrespective of the responses to the post, correct..wrong ..deviation from what is asked. Feedback wi...
by Veera
Fri Apr 20, 2007 6:45 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Finding PLAN(or Package)
Replies: 6
Views: 13194

Yeah acevedo..this is exactly was going on my mind tooo.....well i am thinking of initating a topic on FEEDBACK in GENERAL DISCUSSIONS FORUMN.

Wish ppl understand this is in right sense.

Thanks,
Veera.
by Veera
Fri Apr 20, 2007 6:35 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: what s the difference between DB2 & ADB2?
Replies: 8
Views: 17556

Richard do not take it in wrong sense .... Please watch your words Richard, Dick is one of the senior member not only in this site but various other technical sites....may be he mistook ur requirement ..its not that somebody doesnt know the diff and he also suggested to google it....please take this...
by Veera
Thu Apr 19, 2007 2:52 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Various Locking mechanism for cursors and other SQL?
Replies: 3
Views: 11209

Chandra Shekar, Its very vast and interesting topic , can't be summarized in a note there will be lots of documents in GOOGLE OR DB2 MATERIAL IN OUR IBMMAINFRAMEGURU SITE you can go thru those for more detailed understanding. Find below some info @ high level to just give the basic understanding.......
by Veera
Wed Apr 18, 2007 6:26 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 table -selective download to a flat file
Replies: 4
Views: 10144

Rinu, Ok let me define ur requirement first 1. You have a transaction file -> This File has field AGENT-NO 2. you have a table AGENT -> Which consists of AGENT-NO,EMPLOYEE-NO...and some more columns. Now what is required is you need to get the EMPLOYEE-NO corresponding to the AGENT-NO from ur I/P tr...
by Veera
Tue Apr 17, 2007 9:06 pm
Forum: OTHER SUBJECTS
Topic: Need information regarding job openings in USA on Mainframes
Replies: 4
Views: 13952

Uday, Yeah there are openings but it depends on how well we are equipped with the skill sets , The kind of domains and clients we have worked with. And the years of EXP we have. All projects in Mainframes are Legacy systems so there is always at least scope for few openings for Maintenance part of i...
by Veera
Tue Apr 17, 2007 2:01 am
Forum: JCL
Topic: accessing net via job
Replies: 2
Views: 12358

Tejas, Well i have seen running the MAINFRAMES JOBS from WINDOWS OS....or thru other languages interface like JAVA .... WELL I AM NOT REALLY SURE IF WE CAN ACHIEVE WHAT YOU HAVE ASKED FOR :) . May be IF some one has done something on this already will able to guide us or give some pointers. I am jus...
by Veera
Tue Apr 17, 2007 1:47 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Updating a Table?
Replies: 4
Views: 8646

Dick Brenholtz -> Well thanks for getting the attention for this post, My interpretation of the question was if we can update the table without using COBOL + DB2 and is it possible thru any of the SPUFI, QMF, Princeton, any other tools ...and then I taught as you have mentioned it can be done thru a...