• 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,605 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...

    CharlieBrowne61,425 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:
  • Exporting Active Directory user info to CSV

    Can we export all of our AD data to a CSV file for backup purposes? Can we export the passwords as well? Will they  be encrypted? Where can we find the encryption key so we can make heads or tales of them.

    Karl Gechlik9,860 pointsBadges:
  • Sending an email with a link to a .csv file that’s too large to email

    My program creates a .csv that is copied to the IFS. It is too large to attach to email. I want to send an email with a link to the file. How do I do that?

    Kprazor45 pointsBadges:
  • Trying to run remote command to view AS/400 UNC and failing!

    I need some ideas here...I'm stuck. I'm running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files...

    Koohiisan5,045 pointsBadges:
  • Using IBM System i Access can I replace zeros with blanks in a downloaded CSV file?

    Hi, I have a simple file transfer from my iSeries(AS/400) to a CSV file.  I have a numeric field with 2 decimal places.  The file is sent to an outside agency.  They need zero values to contain blanks.  Is there a way to do this? Thanks for your help.  

    BCF5 pointsBadges:
  • Error using CPYFRMIMPF

    I have a .CSV file that contains a header record and then several detail records (random number as it is the EDI invoices). I use the CPYFRMIMPF to copy the first record to the header file and then I do it again for record 2 to *end. The problem is that it will copy the header fine but then it will...

    Cooking5 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.

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

Following