Forum: IFS

Hi I am trying to save an Excel workbook as a csv directly to the IFS using a macro. This is what I've got so far: Sub Macro() ' ignore messages Application.DisplayAlerts = False

Wondering if there is a possibility that when a file is added/created on an IFS directory it triggers an event. We basically have a process where a file will be dropped to a directory (file name will be different each time) and upon when added, it needs to be processed (real time). However,...

Hey gang! First time poster, although been lurking for a few. I have a directory on the IFS, lets call it '/my directory' that has multiple files dumped to it throughout the day. What we want is a real-time process that when a file gets written to the directory, it is immediately read,...

I have quite a few processes where I retrieve a text file from an FTP site, use CPYFRMIMPF to get the data into a native database file, then run RPG pgms over it. Until now, i have simply ensured that the file was a single file with the same filename. This is all done through a scheduled CLP and...

Hi, IFS meaning please why use this.I know from google.But please tell me real senario Thanks giri

Hi, We get a .tar.gz file ftp'd to our IFS each week and I would like to know if I can unzip the file using standard system I functionality via a program so the whole process can be automated. Currently, I'm unzipping it manually, then copying the contents back to the same IFS directory and then...

Hi All, How could I check the existence of the stream file in IFS? Suppose I have a stream file /TEST/print.xml then how can I know that this particular stream file is exist inside an Directory. Is there any API to find out the same. Thanks in advance. Regards Skma:rolleyes:

hi, i wish to download saved query/400 definitions from as/400 to my pc and view them on my pc. any way possible? is not possible i wish to know if i can just download them in some form and upload to another as/400 and be able to view them there. i cannot use ftp or save files. only available...

Hi, I want to move my report output to one of my shared drive in my PC. So that any body can view the report who has access to it. Could you please help me out on this? Thanks.

Hi All, I am executing FTP command through AS400. When I am running script interactively, it is giving "Spawn id exp3 not open" error. Call QP2TERM and execute below command : /QOpenSys/opt/freeware/bin/expect -f tmp/expectScript.txt

I am trying to do a COPY or MOVE in the IFS in a batch CL program using the following command: COPY OBJ(&FILEOUT) + TODIR('/CONAIR/QAS/ENTERRA/SENT') Where Fileout = /conair/qas/enterra/ZIPPED/OPEN_ORDERS .ZIP When I execute the program I get...

my requirement : The user will receive an email which needs to be moved to AS400 IFS folder. Is this possible ? if yes please can anyone guide me thro' Thanks,

of how to read a file from the IFS. You happen to have any of those laying around?

Ok, need some help here... I have searched through the forum but not having much luck. I have an application on the AS400 that will allow the user to enter an SQL statement and an email address on the AS400. The program will run the command and place the output into the IFS. It will then...

On the As400 I have a directory /tmp and there are two directorys under that one that I'm concerned with. They are /tmp/BAGDATA and /tmp/DAAS. Here's the problem: I used the DAAS directory a year ago for a project and now I have another that needs to create files from the AS400 and put them into...

Greetings, I have read records from an IFS file to update our system and I have written records to another IFS file to then send to an outside system. What I would like to do is to read an IFS record, scan and replace lower case letters with upper case ones and then write that record back to...

We currently map external Windows Server directories to the IFS directory called QNTC. Someone asked if we could do the same mapping with Windows or UNIX directories to QDLO (Document Library Object) folders. Why the @#$* would I want to do this, you may ask? .. So we can use an as/400 utility...

I am trying to find out how I can do this preferably from the i5 we have. I am having problems doing this from any other method then using an FTP client (which don't all work) I did a search but it turned up a couple of bad links. Any help is appreciated.

mput *.835 /pgpclients/qms/qms835/ (replace I am trying to move files from a windows box with the extension .835 to our IFS for encryption. I am issuing the FTP command from our IBM I5. What is the syntax for moving multiple files?

Hi, I am trying to list files in a IFS drive into a PF. Below is the command I am using. ls /Drive > qsys.lib/mylib.lib/myfile.file/member.mbr When "myfile" is a externally described PF with a DDS, it is failing. But the same command is working properly when I create the file as a flat...

I need to retreive an XML documnet from the IFS. I've done this with MQ before and then parse the XML message in an RPG pgm. I need to know how to get the XML message from the IFS to be able to parse it. Can anyone help? I don't need help parsing just retreiving it from the IFS in RPG. Thanks!

Hello All, Could any one help me in finding out how to check which X25 lines are used to communicate between two interfaces ? Thanks Vinod

Hi - I am using the CVT2CMD to generate reports as .pdf documents and was wondering if anyone has applied code to password-protect the documents... I understand that this can be done in Acrobat Reader. Any help is appreciated - Waz

sorry misundertand prob thanks you and happy new year