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 [...]
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 [...]
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 [...]
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 copying Database file to [...]
Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!
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 [...]
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 issue within in my [...]
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 [...]
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. [...]
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
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) TOSTMF(/temp/tst.csv) + MBROPT(*REPLACE) STMFCODPAG(*PCASCII) [...]
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). Unfortunaltely, [...]
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 [...]
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 [...]
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 [...]
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 + ‘s/”"//g’ *BCAT ‘/’ *TCAT &USER + *TCAT &WOUTFN [...]
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.
We have 3500 new ad users. How can we import their usernames, full names, phone numbers, email addresses from a CSV file.
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 [...]
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?





