Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 504
  • Last Modified:

How to convert the oracle report 2.5 output into .csv file(comma delimitted file)?

I want my report output to be generated in a .csv file.so i ran the report and
specified destype as 'FILE' and in the desname i had specified the file destination name where the .csv file to be generated.But it is creating a junk file .Can anyone of you  suggest me how to convert the reports 2.5 output into .csv file
 
Software used:Developer 2000 Report Designer 2.5 on Windows Nt platform
                           with oracle 7.3.4 as backend.

Thanks and Regards,
Hari
0
okhari
Asked:
okhari
1 Solution
 
renurajCommented:
set System parameters

MODE - character
DESTYPE - File
DESNAME - <filename>.csv

It creates a junk file if the mode is not changed to character.

Regards,
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
JgouldCommented:
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now