 |
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 30 matches |
| Author | Message |
|---|---|
 Topic: MS Access SQL Query Help |
|
| spalanis Replies: 1 Views: 2974 |
 Forum: Database Posted: Mon Nov 17, 2014 7:08 am Subject: MS Access SQL Query Help |
| Dear All,
I have a MS Access DB source data in the format listed below. Status Location Count Team# Team Name Billable Offsite 7 1 Team1 Billable Offsit ... |
|
| Topic: REPORTING USING ICETOOL (PREFERABLY) |
|
| spalanis Replies: 5 Views: 3164 |
Forum: Utilities Posted: Wed May 11, 2011 11:31 am Subject: REPORTING USING ICETOOL (PREFERABLY) |
| Thanks a Lot Kolusu. | |
| Topic: REPORTING USING ICETOOL (PREFERABLY) |
|
| spalanis Replies: 5 Views: 3164 |
Forum: Utilities Posted: Fri May 06, 2011 1:30 pm Subject: REPORTING USING ICETOOL (PREFERABLY) |
| I meant, any key length will do. I will refer the solution and will enhance further to fit my requirements. | |
| Topic: REPORTING USING ICETOOL (PREFERABLY) |
|
| spalanis Replies: 5 Views: 3164 |
Forum: Utilities Posted: Fri May 06, 2011 1:28 pm Subject: REPORTING USING ICETOOL (PREFERABLY) |
| Hi Kolusu,
Yes. For A-02 I have headers present in two rows. The above data is just a sample data. You can use the data as is. For convenience, you can use LRECL as 132 for both files. Sure Ko ... |
|
| Topic: REPORTING USING ICETOOL (PREFERABLY) |
|
| spalanis Replies: 5 Views: 3164 |
Forum: Utilities Posted: Fri May 06, 2011 11:40 am Subject: REPORTING USING ICETOOL (PREFERABLY) |
| My Input looks like:
A-02 DISCREPANCY FOR DEPT : 12345 FOR THE STUDENT IN A-02ACLASS: 5A N-05 STUDENT SRINI ASSIGNED TO CLASS : 5A N-05 STUDENT SRINI ASSIGNED TO CLASS : 5B N-05 ... |
|
| Topic: Display non-printable character in HEX |
|
| spalanis Replies: 3 Views: 3166 |
Forum: Application Programming Posted: Thu May 05, 2011 10:53 am Subject: Display non-printable character in HEX |
| Thanks Kolusu | |
| Topic: Display non-printable character in HEX |
|
| spalanis Replies: 3 Views: 3166 |
Forum: Application Programming Posted: Mon Apr 25, 2011 11:03 am Subject: Display non-printable character in HEX |
| FOr ex: My output file should have something like below.
Text X'010D' is non printable character. (I took X'010D' for just an example) |
|
| Topic: Display non-printable character in HEX |
|
| spalanis Replies: 3 Views: 3166 |
Forum: Application Programming Posted: Mon Apr 25, 2011 10:40 am Subject: Display non-printable character in HEX |
| Dear all,
I have a requirement to "display the HEX value" of nonprintable character. I know that the ASCII allowed table lst is : " |
|
| Topic: Date Logic |
|
| spalanis Replies: 1 Views: 1311 |
Forum: Utilities Posted: Sat May 29, 2010 2:34 am Subject: Date Logic |
| Dear all,
I have an input file with the below format. 08110~001~04001~ ~010186 The last 6 bytes are date in MMDDYY format. I should write records to O/P file only if the date(MMDDYY) greater ... |
|
| Topic: Help Needed in "ORDER BY" on a character |
|
| spalanis Replies: 12 Views: 4683 |
Forum: Database Posted: Thu Nov 19, 2009 6:49 am Subject: Help Needed in "ORDER BY" on a character |
| Kolusu,
As always, thanks a lot for your selfless assistance here. Srini |
|
| Topic: Help Needed in "ORDER BY" on a character |
|
| spalanis Replies: 12 Views: 4683 |
Forum: Database Posted: Wed Nov 18, 2009 5:39 am Subject: Help Needed in "ORDER BY" on a character |
| I thought of adding a leading space to the form. But How can I achieve it through DB2 UDB SQL. Please advice. | |
| Topic: Help Needed in "ORDER BY" on a character |
|
| spalanis Replies: 12 Views: 4683 |
Forum: Database Posted: Wed Nov 18, 2009 3:11 am Subject: Help Needed in "ORDER BY" on a character |
| In DB2 UDB Stored Procedure, I have a Character field of length 10. This field has both numeric and character data. See example below.
CA2004 CA2300 65161 100803 When I sort this data, I have t ... |
|
| Topic: Help in Group by function |
|
| spalanis Replies: 1 Views: 1410 |
Forum: Database Posted: Tue Nov 18, 2008 11:07 am Subject: Help in Group by function |
| If my select statement has :
SELECT B.POL_NO, B.POL_EFF_DT, B. ... |
|
| Topic: ICETOOL help needed |
|
| spalanis Replies: 2 Views: 1914 |
Forum: Utilities Posted: Mon Aug 18, 2008 12:10 pm Subject: ICETOOL help needed |
| Hi Kolusu,
This solution works. Thanks for your help. Thanks, Srini |
|
| Topic: ICETOOL help needed |
|
| spalanis Replies: 2 Views: 1914 |
Forum: Utilities Posted: Mon Aug 18, 2008 10:09 am Subject: ICETOOL help needed |
| Hi all,
I am trying to accomplish the following in one signle step using ICETOOL utility. Could anyone please suggest how I should go about it?. I have an input file which looks like : A 014 C ... |
|
All times are GMT - 5 Hours |