 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 20 matches |
| Author | Message |
|---|---|
 Topic: How to find the min and max varchar field size in db2 table? |
|
| sonika2008 Replies: 2 Views: 1733 |
 Forum: Database Posted: Mon Oct 08, 2007 10:34 am Subject: How to find the min and max varchar field size in db2 table? |
| Thanks for your quick response!!
Its working fine. |
|
| Topic: How to find the min and max varchar field size in db2 table? |
|
| sonika2008 Replies: 2 Views: 1733 |
Forum: Database Posted: Mon Oct 08, 2007 9:53 am Subject: How to find the min and max varchar field size in db2 table? |
| I have a varchar field in table. I wanted to know the minimum and maximum size for varchar filed, the MIN and MAX function can only use for the numeric data type. Is there any function from which i ... | |
| Topic: Problem with disp parameter |
|
| sonika2008 Replies: 7 Views: 14209 |
Forum: Utilities Posted: Mon Oct 01, 2007 12:49 pm Subject: Problem with disp parameter |
| the file in the previous step is not created.what should I use in UNIT parameter instead of UNIT=TAP5,,DEFER)? so that i will not get the error for disp parameter mismatch | |
| Topic: Problem with disp parameter |
|
| sonika2008 Replies: 7 Views: 14209 |
Forum: Utilities Posted: Fri Sep 28, 2007 10:24 am Subject: Problem with disp parameter |
| no , I am not restarting, these steps are in one PROC in sequence. | |
| Topic: Problem with disp parameter |
|
| sonika2008 Replies: 7 Views: 14209 |
Forum: Utilities Posted: Fri Sep 28, 2007 10:06 am Subject: Problem with disp parameter |
| hi ,
this is my JCL //STEP02A EXEC PGM=M2806LTX //STEPLIB DD DSN=ENDH2.H06PCCLM.SBATLOAD,DISP=SHR // DD DSN=SYS1.LE.SC ... |
|
| Topic: MAXSORT Syntax |
|
| sonika2008 Replies: 7 Views: 9388 |
Forum: Utilities Posted: Wed Sep 26, 2007 2:25 pm Subject: MAXSORT Syntax |
| Thanks for your response.
My job run successfully , I used 200 in DYNALLOC for SYSDA. but my concerns is I have to execute the 300M records for other tables, so I am looking for other options, and I ... |
|
| Topic: MAXSORT Syntax |
|
| sonika2008 Replies: 7 Views: 9388 |
Forum: Utilities Posted: Tue Sep 25, 2007 2:00 pm Subject: MAXSORT Syntax |
| I am using the syncsort .I have run the job, and its giving U016 abend .
EXEC PGM=SYNCSORT, PARM='MSG=AP,DYNALLOC=(SYSDA,NNN)' can you please tell me what is the max no for ... |
|
| Topic: MAXSORT Syntax |
|
| sonika2008 Replies: 7 Views: 9388 |
Forum: Utilities Posted: Tue Sep 25, 2007 12:04 pm Subject: MAXSORT Syntax |
| hi,
can anyone please provide me the MAXSORT syntax. I want to sort the millions of record. |
|
| Topic: Need a JCl for submitting multiple Jobs from single JCL |
|
| sonika2008 Replies: 6 Views: 9319 |
Forum: Job Control Language(JCL) Posted: Fri Sep 21, 2007 10:10 am Subject: need a JCl for submitting multiple Jobs from single JCL |
| Hi,
I want to submit a multiple job(100 Jobs) from single JCL.is it possible can I submit all jobs from single JCL? if yes, please give me the test jcl? |
|
| Topic: How to get the output like (country,city)=(India,Hyd) in Sql |
|
| sonika2008 Replies: 4 Views: 2405 |
Forum: Database Posted: Tue Sep 18, 2007 8:38 am Subject: How to get the output like (country,city)=(India,Hyd) in Sql |
| Thanks a lot!! | |
| Topic: How to get the output like (country,city)=(India,Hyd) in Sql |
|
| sonika2008 Replies: 4 Views: 2405 |
Forum: Database Posted: Tue Sep 18, 2007 8:21 am Subject: How to get the output like (country,city)=(India,Hyd) in Sql |
| The table is like:-
country city state India Hyd AP India BLR karnataka India Pune Maharastra This is just the sample table. |
|
| Topic: How to get the output like (country,city)=(India,Hyd) in Sql |
|
| sonika2008 Replies: 4 Views: 2405 |
Forum: Database Posted: Tue Sep 18, 2007 8:01 am Subject: How to get the output like (country,city)=(India,Hyd) in Sql |
| Hi,
what should I use in SQL query that I get the output in this format: (country,city) = (India,Hyd) (country,City) = (India,Blgr) |
|
| Topic: how to concatenate two rows in single row? |
|
| sonika2008 Replies: 4 Views: 2736 |
Forum: Database Posted: Wed Sep 12, 2007 12:11 pm Subject: how to concatenate two rows in single row? |
| I have a SQL statement that fetches ID, SR.No, place information.
like this:- ID Sr. No Place 123 x abc x defI want that if the Sr.No is same , than palce information display in one row like ... |
|
| Topic: How to find the primary key for DB2 table? |
|
| sonika2008 Replies: 5 Views: 6308 |
Forum: Database Posted: Wed Sep 05, 2007 9:30 am Subject: How to find the primary key for DB2 table? |
| Thanks for your reply.
I have used SUPERC utility for comparison, but its not working fine for millions of record.Right now I am using the File-manger compare utility, for that compariosn I need to ... |
|
| Topic: How to find the primary key for DB2 table? |
|
| sonika2008 Replies: 5 Views: 6308 |
Forum: Database Posted: Wed Sep 05, 2007 8:48 am Subject: How to find the primary key for DB2 table? |
| Thanks for your quick response!!
Actually, I was trying to find primary key in order to uniquely identify the rows for comparison purpose (I am unloading 2 versions - older and newer - of Image cop ... |
|
All times are GMT - 5 Hours |