• 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?

    deepu93213,695 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:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files... Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me out in...

    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:
  • 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:
  • Merging Excel or CSV file to Active Directory

    How can I automatically add users email addresses to their active directory profile? Their email address is their first initial followed by their last name at our domain dot com. I can create an excel or csv file with the data necessary but how can I merge it into AD?

    NewnanIT1,110 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,020 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