- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- generate flat files
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 05:03 AM
тАО12-19-2007 05:03 AM
Regards,
Gyan
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 05:07 AM
тАО12-19-2007 05:07 AM
Re: generate flat files
This is remarkably like your previous query:
http://forums12.itrc.hp.com/service/forums/questionanswer.do?threadId=1184948
Regards!
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 05:11 AM
тАО12-19-2007 05:11 AM
Re: generate flat files
Hi James,
As requirements change.... the forum changes :)
Regards,
Gyan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 05:20 AM
тАО12-19-2007 05:20 AM
Re: generate flat files
write an sql file,
set pagesize 0
set linesize 10000
set feedback off
spool file.lst
select col1 || '|' || col2 || '|' || col3
and execute it
sqlplus user/pass@TNS @sqlfile..
Hasan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 07:19 AM
тАО12-19-2007 07:19 AM
Re: generate flat files
At the same time can i pass a shell variable to that sql file ,perhaps the below thread can be linked to this one. http://forums12.itrc.hp.com/service/forums/questionanswer.do?threadId=1185452
Regards,
Gyan
bottomline: To be done on the db side(using plsql)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 09:58 AM
тАО12-19-2007 09:58 AM
Re: generate flat files
Sorry i don't have a database to play with it right now but basically, you just have to use the following:
Set serveroutput on
Spool flatfile.txt
declare
begin
dbms_output.put_line(...)
end;
/
hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 10:38 AM
тАО12-19-2007 10:38 AM
Solutionfirst approach should always utilize a favorite search engine of your choice :-)
A google with
"oracle flat file stored procedure"
on germanys google gives this hit on page one item 4 or 5:
http://forums.oracle.com/forums/thread.jspa?threadID=233148
I'll guess the solution there is not working first hand, but you should be able to work through oracle documentation and get a solution with this as a sample.
The solution there uses UTL_FILE.-functions
which have a good intro here
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/x/Utl_File/start.htm
Good luck
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-29-2007 09:19 AM
тАО12-29-2007 09:19 AM
Re: generate flat files
Regards,
Gyan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-31-2007 03:51 AM
тАО12-31-2007 03:51 AM