• RPGLE Flat File

    how can i keyed a flat file in RPGLE

    Hemavijay85 pointsBadges:
  • Program Described file

    I have defiend the program described file (flat file) as update mode and defined the data structure (for the flat file). i'm trying to update the specifice data that i structured in DS. But, when i try to compile, i'm getting an compilation error saying that record format as not defined (for update...

    Spenzer25 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • Update a flat file through CL

    Hi, I have copied a message from MSGQ into a CL variable. Is it possible to write that message in a flat fiile through CL.

    Cool400115 pointsBadges:
  • spool to flat file from SQL editor

    I am using SQuirel SQL to execute queries against an AS400. I need to be able to execute a series of queries and export the results to a flat file on the local client. Can someone give me the idiots guide?

    Daowebe20 pointsBadges:
  • Numbers of records in flat file without opening it?

    Can we find the number of records in the files using the parameters Space used , Space allocated, LRECL, BLKSIZE in mainframe or are any other parameters required. I have to find the no of records without opening the file or even accessing it. Is it possible.

    K19085 pointsBadges:
  • Single “Filler” Field Flat File vs Multiple Fields Defined Flat File

    What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields? For example: Physical File: TESTFILE1 R TESTFILE FIELDA 50 Physical File: TESTFILE2 R TESTFILE DEFINED1 20 DEFINED2 10 DEFINED3 5 DEFINED4 15

    AWDSYSMGR20 pointsBadges:
  • RPG edit code for signed value

    Hi I have moved a numeric value to a ds. I have used this EVAL F1 = %EDITC(ABC:'3')-here F1 is part of flat file DS and there are decimals required in the output file.I am getting the decimals but my problem is that ABC field from i/p file could be negative but am not sure how to get the sign to...

    0 pointsBadges:
  • How to send the data from a Physical file to a Flat file

    Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF E DISK FSAAPH...

    Askt1140 pointsBadges:
  • How do I convert a Unix text file from IFS to a DB file on AS400?

    I've got a flat text file that I want to convert from AS400 IFS to a Database file. First I want to convert to a flat file just to prove I can. The File is being Sent via FTP from Unix to AS400/IFS. Files have been sent in both unix txt format and MDOS format. Both files can be displayed on IFS no...

    slack4002,705 pointsBadges:
  • Flat files

    I have a data in data strucure then after i need to create flat files in txt format. please suggest me how can i proceed.

    Askt265 pointsBadges:
  • Spool to Flat

    Can anyone please guide me on the following: 1) How can I convert Spool to Flat and vice cersa ? 2) If I already have a Flat file. Can I convert it back into spool ? using what utility ? 3) What are the archivers that convert Flat to Spool and vice versa ?

    SyedJR10 pointsBadges:
  • Copy data from flat file to a flat file

    My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...

    Supriyob2165 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • Update in SQL

    I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE SET SUBSTR(FLAT_FILE,2,2)= 'AA' WHERE SUBSTR(FLAT_FILE,1,2) = 'HH' The above SQL Query is throwing an error SQL0104 for missing token. Can anybody suggest me on the above. Thank...

    Vids295 pointsBadges:
  • Inserting a flat file into a temporary table

    I need to take a flat file and insert it into a temporary table, then use that table to delete from another table all rows based on "col 7" of the temp table which may have duplicate values. Then from the temporary add to the perm table all rows. Do you have any suggestions, step by step for this...

    ITKE351,965 pointsBadges:
  • How can I define a flat file in RPGLE?

    How can I define a flat file in RPGLE?

    Claudiarce5 pointsBadges:
  • Problems with tranferring flat file from mainframe to Outlook as CSV file

    I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

    Rickb19745 pointsBadges:
  • Actuate 8 enterprise reporting tool,Text files

    Hello, Am currently using actuate 8 as a reporting tool.The major problem encountered is to deal with flat files with fields separated with other delimiters other than commas.For example I encountered a flat file delimited with back slash am unable to tackle.Is there any way out in Actuate 8 or...

    Ingosi10 pointsBadges:
  • how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.

    how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

    It doubts85 pointsBadges:

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