80 pts.
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...
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...
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?
Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?
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.
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.
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?
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?
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.
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.
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 ...
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 ...
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...
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...
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 ...
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 ...
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.
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.
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...
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...
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 ?
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 ?
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...
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...
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...
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...
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. ...
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. ...
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...
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...
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...
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...
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...
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...
