Export table data in a flat file without using FL

Advertisement

Hi,
I am looking for options where I can export table data into a flat file without using FL(File Layout) i.e., by using App Engine only.
Please share your experience if you did anything as this
Thanks

Advertisement

A simple way to export any record (table/view) to an csv fiel, is to create a rowset and loop through all record fields, like below example code
Local Rowset &RS;
Local Record &Rec;
Local File &MYFILE;
Local string &FileName, &strRecName, &Line, &Seperator, &Value;
Local number &numRow, &numField;
&FileName = "c:\temp\test.csv";
&strRecName = "PSOPRDEFN";
&Seperator = ";";
&RS = CreateRowset(@("Record." | &strRecName));
&RS.Fill();
&MYFILE = GetFile(&FileName, "W", %FilePath_Absolute);
If &MYFILE.IsOpen Then
   For &numRow = 1 To &RS.ActiveRowCount
      &Rec = &RS(&numRow).GetRecord(@("RECORD." | &strRecName));
      For &numField = 1 To &Rec.FieldCount
         &Value = String(&Rec.GetField(&numField).Value);
         If &numField = 1 Then
            &Line = &Value;
         Else
            &Line = &Line | &Seperator | &Value;
         End-If;
      End-For;
      &MYFILE.WriteLine(&Line);
   End-For;
End-If;
&MYFILE.Close(); You can of course create an application class for generic calling this piece of code.
Hope it helps.
Note:
Do not come complaining to me on performance issues ;)

October 11, 2015

Export table data in a flat file without using FL

Hi, I am looking for options where I can export table data into a flat file without using FL(File Layout) i.e., by using App Engine only. Please share your experience if you did anything as this ThanksA simple way to export any record (table/view) to

Exporting Table data to delimited txt file

I am trying to import the table data into delimited text file, I am running the following code from Tom Kyte's website on the server. When I run the procedure after I run the function it is not creating any .dat file for me. I have also checked for t

How to Export Table Data to a excel sheet using OPENROWSET

Hi Team, I would like to Export table data to a excel sheet by using "OPENROWSET" command in SQL Server but I am getting the below error message Column name or number of supplied values does not match table definition. Please help me on how to e

BAPI to upload data from a flat file to VA01

Hi guys, I have a requirement wherein i need to upload data  from a flat file to VA01.Please tell me how do i go about this. Thanks and regards, Frank.Hi previously i posted code also     Include           YCL_CREATE_SALES_DOCU                       

Data loading from flat file to cube using bw3.5

Hi Experts,                    Kindly give  me the detailed steps with screens  about Data loading from flat file to cube using bw3.5        ...............PleaseHi , Procedure You are in the Data Warehousing Workbench in the DataSource tree.       

Embed flash file without using IFrame UI

Hi all, Can any one tell me how i can embed flash file without using IFrame UI ?Hi To run a flash file you will definetely need a platform for which you need a shockwave player or a simple browser window. From webdynpro, the purpose of making it run

Process chains from the flat file by using filezilla client version in  BI

Hi experts, please let me know how to create the process chains from  flat file by using filezilla client version. so far, I didn't work with file zilla FTP. can anybody give detailed step by step procedure to find the flat files and download them an

Exporting Multiple Internal table data to Single Excel file.

Hello Expert,   I want to export more than one internal table data from Web Dynpro Application to single Excel file but in such a way that each table's data to be get exported to different tabs in (Multiple sheets)  that single excel file. So help me

Exporting table data to a Comma Separated file / .dat file?

Hi All, I want to export the table data to a .CSV or .DAT file. This data is an input to other software to read and load like "Informatica". I tried spooling the file by providing the extension as .CSV but that did'nt work! Could you please let

Loading Date fields from flat file to Oracle tables

Hi, I have a flat file with a few date columns. I have given the format for the date field while creating the data store for the flat file. The format I used is 'YYYY-MM-DD'. But I get an error when I execute it after associating the module with LKM

How to skip first record while inserting data from a flat file to BW system

Hi Experts, In my project we have to upload flat file into a BW system. I have written a program and it is working fine. Now we have got another requirement. The flat file will have a header record (first row). While uploading the flat file we have t

Need a query for export table data .....

Hi, I need a query for exporting the data in a table to a file. Can anyone help me ? Thanking You JeneeshSQL> spool dept.txt SQL> select * from dept;     DEPTNO DNAME          LOC         10 ACCOUNTING     NEW YORK         20 RESEARCH       DALLAS  

Exporting a view to a flat file

Hi all, Running Oracle 9i on Windows. We have a stored procedure which runs a number of packages and populates a view called v$logmnr_contents. We woudl like to export the contents of the view to a flat file so that it can be transferred over to anot

Export table data

How to export the all tables data of a schema without administrator login ? SanjayHello Sanjay, you could use the "old" export (exp) if you have a database client installation somewhere. You can usually use the schema owner for that export. Othe

Null data in the flat file

HI , i have generated a flat file after extracting data from oracle database. my table has 10 fields and out of which second and third fields are null.. But after populating the data in the file, i could not see the empty spaces for those fields, the

Date format in flat file of bdc

Hi Folks, In BDC I have a flat file which has to be uploaded from a flat file and 4 users are using each of one has their date format. so inorder to get their required date format what i need to do .Hi,        use the below logic in your code. SELECT

Reg: Export table data into CSV

Hi Experts, I'm stuck up with a requirement, where I have to export data of all tables from a schema into separate table specific CSV files. I tried using SQL Plus 'SPOOL' but it gives me additional queries executed on top of CSV generated. Also, i'm

Data updation from flat file to I.C. via ODS

Hi, I have to load transaction data from 4 tables into 4 ods and these 4 ods data will be loaded to 1 info cube.so please tell me the best method whether to use 4 info sources for 4 ods or can i define all the info objects in one info source and use

Uploading Data from a Flat file into Oracle Database

Hi, I am a novice to Java . SO, please bear with me. I have a reqiurement where I have a flat file or excel file from which I need to read the data and insert into Oracle Database. The falt file will exist on the client machine. I have been reading a

Sorting data in a flat file

I am having several flat files which contains my share transaction in CSV. I want to sort them on transaction date basis and want to update them for any selling or bonus share transaction. Anyone please help me in this.I am having several flat files