error cpf1120- user xxxxx does not exist.
i give the correct user id and password

If you get CPF1120 with that appropriate text, then you are reaching some AS/400 and the user profile that you entered does not exist on that AS/400.

There’s no way for us to tell if you’re reaching the correct AS/400.

Tom

Here is what I came up with. …

If only read authority exists, your two-part FTP solution was pretty much what came to mind for me.

Tom

CharlieBrown,
How do you know the file name to rename inside the ftp session?
mget 20120406*.csv
rename 20120406*.csv 20120406*.PRX <<<<would this work?

Kinda a combination of both suggestions.
Nick

CharlieBrown, Bigkat – thanks for the prompt response.
I doubt I have anything but ‘read’ authority on their server. I could try that. That would be a good way.

Bigkat, not sure yet how often this will run. Most likely once a day, late at night for the current day. A guy here had also come up with that (20120406*.csv) plan.

Here is what I came up with.
Two connections.
First- connect, dir, quit. Read through the ftp log, parse the filename, chain out to a file with all previously downloaded filenames. If not found(we haven’t downloaded it before), update/write a different script file with the new-exact file name to get.
Second- connect, get new files, quit. Read the ftp log, parse the filenames, add them to the file with previously downloaded file names.

Then I can kickoff the conversion programs to build db files we can use.
I think it is a plan, just had to think on it a bit.
How does that sound?

You two probably have the easier way and less coding now that I think about it. I will check on the rename authority. If not, I will use the current date to change the script file.

how often does this run???

if daily, you could mget 20120406*.csv
or even hourly, mget 20120406-14*.csv

you would need to have a process update the control script file before you start the FTP session

You can also run linux off a dvd. Just google ‘how to run linux off dvd’.

Maybe this will be more readable.

namefmt 1    
lcd /home/test
cd /out      
mget *.csv   
QUIT         

Path already exists: /home/test/20120405-103602_LoadMaster_040512103326.csv 
Specify REPLACE as a subcommand option.    

i need to print images in foxpro 2.6

it isn’t exactly clear that I bolded the line
AND A.IFDIV = ‘116′
in my reply

your where exists select and your update select have different criteria. The update select is returning fewer result sets.

UPDATE VINITMB A
SET IFOTH = (SELECT coalesce (B.IGCOST,0)
FROM ITEMVND1 B WHERE A.IFITEM = B.IGITEM AND A.IFLOC = 1
AND A.IFDIV = ‘116′)
WHERE EXISTS
(SELECT 1 FROM ITEMVND1 B where B.IGITEM = A.IFITEM AND B.IGLOC = A.IFLOC)

HOW CAN I KNOW FIBER OPTIC NETTWORKING

Thanks BigKat, found the file at /qsys.lib/mylibrary.lib/myfile.file

Hi, I am a BTech (Mechanical Engg) having 3 1/2 years of experience in Mechanical Designing field. Currently pursuing my MBA in 1st year. I want to know which specialization to choose as major & minor (HR/FINANCE/MKTG) and also want to pursue SAP course accordingly to the related specialization, considering my work experience. Plz help me out.

you will need qsecofr to do some of the task on as400. and nope you cannot rename qsecofr.

in mochasoft when i try to log on it arrives an error,

error cpf1120- user xxxxx does not exist.
i give the correct user id and password what i given for create new session .
so please any one help for this issue

thanks
sudha

Or use the command Read Record using CLF (READRCDCLF), which supports reading the previous record with TYPE(*PRV). The command documentation can be found here.

CLF provides a no-charge run-time which includes support for READRCDCLF.

Vendor response:
Your productivity can be improved by using the optional CLF precompiler, which does have a charge.
End of vendor response

Bruce Vining

…when I call the “C” socket() function, I am receiving…

How do you know that’s what you’re receiving? That is, please show the code that determines that an error exists and that the errno is 3452.

Also, what happens before Socket() that might set errno?

Tom

Why is this so diffcult to space so it is readable?

Because it is rendered with HTML.

First, you’re not controlling the font. Simply pasting text without font specification allows the browsers to choose defaults. Second, HTML compresses consecutive whitespaces. If you don’t don’t put formatting codes into the HTML, it will provide default formatting. Third, if you copy/paste without including carriage-return/line-feed characters, you’ll get run-on results from one line to the next. (5250 green-screens don’t have ant CR/LF characters to copy, so none get pasted.)

The editor provides a {code} button. If you surround code with {code} tags supplied by the button, you’ll have better results. The “How to use…” link tells you about this so you don’t have to ask.

This is my error: *RNF7260 30 3 The Factor 2 operand is not valid for the specified operation.

The error apparently says that you have three source lines where you have something in the Factor 2 portion of the instruction that can’t be used there. CharlieBrowne possibly covers two of those.

I’d also question the EXCEPT FILE02 lines. I can’t quite determine what this line is trying to specify:

OFILE02     E                ADD

It’s not clear if “ADD” is intended to be an exception-name or a record-addition code. Either way, there is no exception-name of FILE02; that’s a file-name. (Maybe that works and just isn’t documented.)

Regardless, either 2 or 4 lines seem indicated as possible errors, yet the RNF7260 seems to be telling us “3″.

Without seeing readable code, and possibly more of the code, I don’t know what more can be said.

Tom

Like all HLLs, RPG provides a COMMIT operation for commits and ROLBK for rollback.

Whether or not the commitment definition is appropriate for a particular commit or rollback is a different question.

Tom

If it actually is in a “library” rather than a true directory, then you need to specify the path in the IFS format. BigKat provided an example that shows a full path down to a member level. His example demonstrates the path for a file that exists in the /QSYS.LIB file system which is where all “libraries” exist.

Different types of files might not have members.

Tom