IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Import excel into mainframe file.


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sun Feb 13, 2011 3:46 pm
Reply with quote

Quote:
spreadsheet2 which may have lakhs of rows.


and who is ever going to look at them ?

topic is going to get locked pretty soon ..
first... because it belongs to the category
Quote:
the following repetitive topics are no longer eligible for discussion in any of the following Forums:
Quote:
How to transfer/FTP a file. This topic has already been posted many times. Please search for the answer that best suits your needs, or refer to the proper documentation.
ibmmainframes.com/viewtopic.php?t=20820&highlight=

second because it seems to be shifting toward stubborness/incompetence,bad judgement :icon_cool.gif

from one automatic excel automatic row run an automatic query to produce automatic lakhs of more automatic rows
to be automatically downloaded to an automatic excel automatic spreadshit and from here again...
for each row run a query that will produce lakhs of rows to be downloaded ...... on and on and on ...

oops are ... rows, excel things, queries that are going to be automatically spread around or something else ???
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Sun Feb 13, 2011 4:16 pm
Reply with quote

enrico-sorichetti wrote:
Quote:
spreadsheet2 which may have lakhs of rows.


and who is ever going to look at them ?

topic is going to get locked pretty soon ..
first... because it belongs to the category
Quote:
the following repetitive topics are no longer eligible for discussion in any of the following Forums:
Quote:
How to transfer/FTP a file. This topic has already been posted many times. Please search for the answer that best suits your needs, or refer to the proper documentation.
ibmmainframes.com/viewtopic.php?t=20820&highlight=

second because it seems to be shifting toward stubborness/incompetence,bad judgement :icon_cool.gif

from one automatic excel automatic row run an automatic query to produce automatic lakhs of more automatic rows
to be automatically downloaded to an automatic excel automatic spreadshit and from here again...
for each row run a query that will produce lakhs of rows to be downloaded ...... on and on and on ...

oops are ... rows, excel things, queries that are going to be automatically spread around or something else ???



I am sorry..pls don't misunderstand me.. icon_cry.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sun Feb 13, 2011 4:24 pm
Reply with quote

I dare to say that the main issue here is that the process is totally unclear to the TS

from a simple
save an excel sheet to a CSV PC file,
FTP the same to a <server>
upon the receipt of the file schedule some process (**)

we went to an unstructured/unclear/fubar' ed <thingie> !

(**) hope You noticed that I did not say mainframe!
whatever the operating system running on the MAINFRAME/SERVER
the logical approach of the issue does not change

c /<server>/mainframe/
c /process/job/
and the terminology will become mainframe friendly

even on non zOS systems <job/process> schedulers exists to trigger something based on the presence of a dataset/file
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Mon Feb 14, 2011 1:53 am
Reply with quote

Yes you are absolutely right..but I m a learner and this may be a petty thing bu new for me.. but now I m clear with my approach & many thanks for your support icon_smile.gif
Back to top
View user's profile Send private message
mtaylor

Active User


Joined: 20 Feb 2009
Posts: 108
Location: Kansas City

PostPosted: Fri Feb 18, 2011 5:48 am
Reply with quote

Here is the issue:

Any process that it is important to an organization should be analyzed and understood. And only then implemented. If it is in fact important to the organization then management should allocate resources to implement a process that has the feature of being 'useful'. Here 'useful' means the people involved can perform the process with the provided implementation quickly, easily, and accurately.

Your process sounds like an ad-hoc cluster flop and only poor management would allow any real business to be based on such a thing.

Therefor, everyone here is incredulous and suspect at the prospect of automating the process you've described hence the responses you've received.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PC Guides & IT News

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 0
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top