 |
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 12 matches |
| Author | Message |
|---|---|
 Topic: Mainframe to Excel |
|
| YVRAMJ Replies: 6 Views: 6491 |
 Forum: TSO and ISPF Posted: Thu Aug 19, 2004 2:14 pm Subject: Mainframe to Excel |
| Hi,
Can we ftp a dataset from host to a network drive as excel ? And also I would like to know how to get a excel file to host. Users want the file to be in excel format only. Please let me kno ... |
|
| Topic: FTP EXCEL work book |
|
| YVRAMJ Replies: 5 Views: 2695 |
Forum: Job Control Language(JCL) Posted: Mon Sep 08, 2003 7:00 pm Subject: FTP EXCEL work book |
| The excel work book is being created from some other sources and some manual intervention. This work book will be located on a shred server and I need to write a batch job with FTP step to get the fir ... | |
| Topic: FTP EXCEL work book |
|
| YVRAMJ Replies: 5 Views: 2695 |
Forum: Job Control Language(JCL) Posted: Mon Sep 08, 2003 2:03 pm Subject: FTP EXCEL work book |
| Hi,
I want to get a specific sheet from a EXCEL work book into host using JCL. I am able to get it if there is only one sheet. But If there are multiple sheets it is not working. Do you have any ... |
|
| Topic: Can we use a CASE statement in UPDATE SQL |
|
| YVRAMJ Replies: 3 Views: 1997 |
Forum: Database Posted: Fri May 16, 2003 10:41 pm Subject: Can we use a CASE statement in UPDATE SQL |
| Hi,
I need sql for the following condition. I have a column PO_NUM CHAR(06) in a DB2 table PURHDR. It's value should be in the range 60000 - 699999. Now I need one SQL to update its value ... |
|
| Topic: SQL question |
|
| YVRAMJ Replies: 3 Views: 1902 |
Forum: Database Posted: Fri May 16, 2003 3:33 pm Subject: SQL question |
| No,
I want to do it all in SQL itself. No host language. |
|
| Topic: SQL question |
|
| YVRAMJ Replies: 3 Views: 1902 |
Forum: Database Posted: Thu May 15, 2003 11:26 am Subject: SQL question |
| Hi,
I have data in DB2 table like this CODE NAME NUM ------- ------------------------------ ---- 60 TEST PROCESS 315 60 TEST ... |
|
| Topic: SQL Date format from Char format |
|
| YVRAMJ Replies: 1 Views: 1606 |
Forum: Database Posted: Thu May 01, 2003 3:38 pm Subject: SQL Date format from Char format |
| Hi,
I found the solution. If I use substr funtion and date function it is working as below. SELECT (DATE(SUBSTR(CUR_QUOTE_ENTER_DT,1,4)||'-'|| SUBSTR(CUR_QUOTE_ENTER_DT,5,2)||'- ... |
|
| Topic: SQL Date format from Char format |
|
| YVRAMJ Replies: 1 Views: 1606 |
Forum: Database Posted: Thu May 01, 2003 3:19 pm Subject: SQL Date format from Char format |
| Hi,
Is there any way we can convert the date value stored as a char(8) column in a DB2 table to a date column ? I tried different scalar functions. I couldn't get it. We use DB2 V7 in our shop. F ... |
|
| Topic: SQL INSERT |
|
| YVRAMJ Replies: 3 Views: 2524 |
Forum: Database Posted: Tue Apr 22, 2003 11:43 am Subject: SQL INSERT |
| Hi,
I got the solution. I passed the variables as parameters and it worked fine. Thanks, Ram. |
|
| Topic: SQL INSERT |
|
| YVRAMJ Replies: 3 Views: 2524 |
Forum: Database Posted: Tue Apr 22, 2003 10:44 am Subject: SQL INSERT |
| Hi,
I am sorry. I forgot to mention about the query. I am storing this query in a DB2 table so that my stored procedure can read it and prepares and then executes. In this process I will be passing ... |
|
| Topic: SQL INSERT |
|
| YVRAMJ Replies: 3 Views: 2524 |
Forum: Database Posted: Tue Apr 22, 2003 9:40 am Subject: SQL INSERT |
| Hi,
How Can I insert into a table values for some columns from one table and rest with values option ? This query is not a working one. I want to know if there is any other way. INSERT INTO ... |
|
| Topic: IEBCOMPR |
|
| YVRAMJ Replies: 1 Views: 5504 |
Forum: Job Control Language(JCL) Posted: Sat Jan 18, 2003 3:40 pm Subject: IEBCOMPR |
| Hi,
I am using IEBCOMPR in JCL to check if the file got changed from the previous run & if it is then using IEBGENER copying it to another file. The IEBCOMPR step is giving return code of 12 if ... |
|
All times are GMT - 5 Hours |