• How to know whether the CSV extraction to PF happened today

    I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the 2 program and have to check in the...

    RamvishakRamesh2,505 pointsBadges:
  • Take .csv files and show that on a subfile

    Hi all, I am pretty new to this type of requirement. There are some .csv fiels in AS400 IFS follder. When user choose to the option - upload from the IFS folder from the menu, I need to show those .csv files as a subfile. From that subfile, user can select the csv file with a 'U' to upload and the...

    RamvishakRamesh2,505 pointsBadges:
  • QEXECSQL command source

    Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this - could you please let me know. Alternatively is there is another better utility for...

    Pclarkeirl5 pointsBadges:
  • Crystal Reports CSV with quotes inside string

    I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: "Andy", 4685, "requires 5" by 2" silver plate", 1132 According to CSV standard it should be: "Andy", 4685, "requires 5"" by 2"" silver...

    Moltar5 pointsBadges:
  • RPG ILE Scan csv file

    I am scanning a comma delimited file for elements to populate a db2 file. However, it is not picking up the last segment because there is no ending comma. How can you recognize the end of a row?

    Streeter45 pointsBadges:
  • Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 pointsBadges:
  • AS400 Shell command

    Hi  Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this...

    iiiiiiiiiiiii335 pointsBadges:
  • Can we change length of CSV File

    Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the legnth of CSV file?

    deepu93214,290 pointsBadges:
  • Finding a stream file CSV

    i have a stream file in CSV format, we are not sure wheere this file is I have find out where this available in AS/400. I tryed wrklnk command and other options but i am not able to find this file. could you tell me the best way to find out this CSV stream file.    

    Askt1140 pointsBadges:
  • Accessing abc.csv AS/400 files

    how to access abc.csv files in as400.i have a abc.csv file,in this file have contain some data but i want to access into my physical file,with out using 3rd party tool.pls give advice

    madhuchowdary350 pointsBadges:
  • Junk characters in CSV conversion through CPYTOIMPF

    Hi, I am sending data from iseries to excel through CPYTOIMPF i've used this command in CLLE, in query output there is a char field value is '01.03.2011' but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY     QRY(ADO150Q) CPYTOIMPF  FROMFILE(ADO150F)...

    Rpgle400tech145 pointsBadges:
  • PM400 screen to print

    PM400 option Print performance report displays the screen (below) to allow the user to drill down.  This screen is a summary with interval of 15 minutes for a 24 hour period.  I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv).  ...

    infiniumpro325 pointsBadges:
  • Data report from iSeries to a CSV format need page breaks and colors

    Hi, I have to send report to our clients in CSV format using data from iSeries. In iSeries I used a text file having one field of 1000 char and used commas as field separators. Is there any way I can send a code for page break once required? Can I do some thing to color or high light the totals and...

    Raza11050 pointsBadges:
  • Excel 2007 – creating a graph from CSV data with a macro

    I want to create a macro that will take a CSV file and remove the same columns each time. BUT the number of rows can vary.  Can I create a macro that will create a grapgh ? The problem is, like i said before, the number of rows can vary each time but the number of columns is consistant.

    jkeri360 pointsBadges:
  • Importing files to as400

    How can I upload a csv file into the as400?

    Ckw5 pointsBadges:
  • As400 directory space

    Hi Can u please let me know what is the command to check the directory space... for example the directory name is ABC,which contains 100 CSV files. i want to check the space allocated by that directory. Thanks

    iiiiiiiiiiiii335 pointsBadges:
  • Report / File repository for AS/400 V5R4

    Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition to just...

    CharlieBrowne41,380 pointsBadges:
  • How to remove the double quotes in CSV file in iSeries

    Hi The command is to remove the double quotes present in CSV file. I have used one shell command. Strqsh cmd(Sed -e 's/""//g' file name > new file name) I have to write this command in CLLE program. CHGVAR     VAR(&RPLC) VALUE('Sed' *BCAT '-e' *BCAT +                 ...

    iiiiiiiiiiiii335 pointsBadges:
  • Removing zeros from .csv file

    I'm creating a .csv file using CPYTOIMPF Command.. I have a numeric Field in the File. I want to remove the zeros since i am not using it regularly. Pls help me

    Babs30 pointsBadges:
  • Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0

    We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...

    Meb10 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