1
  • How to insert double quotes in a flat file

    Hi everyone, I want to insert data in double quotes within a single record. Later I want to split it up. Actually I want to insert column headings in flat file like "sr.no","name","product"  later when I open the file in excel file it should get in different columns Thanks

    hunshabbir71,070 pointsBadges:
  • AS/400 – Flat file

    I wanted change a flat file as a keyed file. What are all the ways there?

    rajeshece1,215 pointsBadges:
  • Reading only the active records in a flat file

    I have a physical flat file which has thousands of deleted records. (I can't get exclusive use of the system to do a reorg) I am doing a sequential read of the file because the file only has a few active records. However, it is taking the program awhile to finish and I'm guessing it is because the...

    GHENDER190 pointsBadges:
  • Read & Write Flat file

    I want to read & write same flat file(CSV).For eg.If I have flat file structure in this way 1'PL','ABC'  2 'PL','DEF'  3'PP','BGC' In this I am reading only PL type of records.If it is PL type like 'ABC'then i am doing some processing & writing 'PL','RIC' record in to the same.After writing the...

    Rr22100 pointsBadges:
  • AS400 Flat file data comparison on Window based third party tool like Examdiff Pro

    My system gets data in flat file for booking.Once the booking is completed , customer sends some corrections data in other flat file. I have to compare both flat files data in window based comparison tool like EXamdiff Pro . if sent correction notes is ok, then update the physical files.  example...

    Kapiltiwari350 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • DB2 table load JCL with current timestamp

    Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

    Manju25 pointsBadges:
  • AS/400 SFTP causes one position shift of data in send file

    Hi Friends,I got a problem.I am copying data from flat file to path and sending on SFTP. after reaching the file oracle, first record loading fine into oralce, but from second record onwards, data shifting to right by 1 postion .  Could you please suggest. Thanks in Advance.    

    Text40 pointsBadges:
  • How to format a flat file using customised FMTSRC

    Hi, I have a falt file.i want to sort it using a customised format source file.Please tell me how to create a source file for formatting the flat-file.I want the sample of a DDS of sort.

    Supriyoas400130 pointsBadges:
  • Flat file or Physical file in as/400?

    How to know whether a file is physical file or flat file in CL/400?.

    Alicsc370 pointsBadges:
  • About FLAT FILE ?

    I am working on V4R4M0 . I would like to know clearly about a Flat File , its uses, and how can we enter data into it ? how to fetch data from it ? Thanks in advance

    SARKNS30 pointsBadges:
  • AS400 Flat files

    Hi, I have a flat files which contains address, phone numbers, etc.. i want to update the address (ABC..) and phone numbers (1234..) for all the records commenly which is placed in some position in the file. Can any one suggest me that how it can be done (any qry or program)? - Jack Spenzer

    Spenzer25 pointsBadges:
  • AS400 I have a flat physical file,this flat file will be updated daily by datewise.I have to use an CLP for copying the records by the datewise daily

    I have a flat physical file ,this flat file will be updated daily by date wise . I have to use an CLP for copying the records by the date wise daily and copy that data to another Physical file and change the naming conventions of the file and send the data to mainfram system using FTP( FTP too we...

    Sunilinline25 pointsBadges:
  • UNABLE TO WRITE TO A FLAT FILE FROM DS

    Hi Am trying to move a data structure to a flat file.The flat file field name is SASAM. The error is The Result-Field operand SASAM is not valid for the specified operation. The data to be written is CCODE and then the value in HCMPYV. Please find code snippet for ur reference FSASAM IF A E DISK F...

    0 pointsBadges:
  • RPG 400 DATA STUCTURES

    Am trying to write to a flat file from a pf using data structures but am getting some errors 'The name specified previously is defined as file or record name. Specification ignored ' Heres the sample code FABCL01 IF E K DISK FDEF O E DISK A F DEF KRENAMEDA100 IABFLAT DS I 1 8 AADT I 9 10 AACM I 11...

    0 pointsBadges:
  • rpg/400

    while i am compiling the below program compile sucessfull and write the records into SA100 (Flatfile). C READ APHL01 C *IN20 DOWEQ *OFF C EVAL EDTE = APIRDT C EVAL CCDE = APCMPY C EVAL ERPN = PHDCPX + %EDITC(PHDCSQ:'X') C EVAL FYEAR = PHDCYR C EVAL INVNO = APINV C EVAL INVDT = AINVDT C WRITE SA100...

    Askt1140 pointsBadges:
  • Suffix a record using SQL

    Hi guys, any ideas how to suffix a record (as400 flat file) using SQL? thanks

    Rockleadme385 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following