Question about IBM Computers & Internet
When executing the following command the it copies only the first field and ignores the rest.
CPYFRMIMPF FROMFILE(QTEMP/JE) TOFILE (GLLIBR/GLXJE)MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM('''') RMVBLANK(*LEADING) FLDDLM(',') RPLNULLVAL(*FLDDFT)
Any ideas are welcome.
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
SOURCE: CSV file to AS/400
FTP is "line oriented." It has no concept of 'database record formats.' It transfers strings of characters with essentially no knowledge of 'fields' or 'columns' that make up 'records.' A 'record' to FTP is usually just whatever string of characters that is found between record delimiters.
Trying to FTP into a DB2 externally-described database file requires having strings of characters that are (1) laid out to match the receiving record format and (2) either are already converted to the proper CCSID and transferred as BINARY, or are ASCII characters that would result in conversions to all the right characters and transferred as ASCII.
Regardless of which alternative is chosen for "(2)", the handling of record format positions that would match up with packed-decimal or other non-character type fields would be very tricky.
That's where a somewhat 'standard' file format such as .CSV comes in.
However, you don't transfer the .CSV file directly over the top of the DB2 file. Instead, you transfer the .CSV file into a simple directory on your AS/400 and then use it as the source for a DB2 import function. On your AS/400, the import function is most often the CPYFRMIMPF command.
The import takes the .CSV file and handles all of the mappings for field positions and data types.
As such, the sequence becomes (1) FTP the .CSV file to the AS/400, and (2) run CPYFRMIMPF on the AS/400.
Note that the format of the .CSV file makes a difference. You need to ensure proper CCSID settings, proper quoting where necessary, proper record separators, etc. Make sure that you generate a .CSV that can be converted to the record format of the eventual target database file. Lots of possible details, but _far_ easier than trying to construct a matching DB2 record format on a different platform.
Posted on Sep 16, 2009
Tips for a great answer:
Sep 18, 2013 | Computers & Internet
on Nov 19, 2013 | SKYPE Computers & Internet
Sep 18, 2013 | Computers & Internet
Boot off the Windows disk and select the "Repair your computer" option from the lower left-hand corner.
Follow through until you get to the option to open the Command Prompt, which you'll want to select.
First you'll want to type in the following command to backup the original sticky keys file:
copy c:\windows\system32\sethc.exe c:\
Then you'll copy the command prompt executable (cmd.exe) over top of the sticky keys executable:
copy c:\windows\system32\cmd.exe c:\windows\system32\sethc.exe
Resetting the Password
Once you get to the login screen, hit the Shift key 5 times, and you'll see an administrator mode command prompt.
Now to reset the password-just type the following command, replacing the username and password with the combination you want:
net user geek MyNewPassword
That's all there is to it. Now you can login.
Of course, you'll probably want to put the original sethc.exe file back, which you can do by rebooting into the installation CD, opening the command prompt, and copying the c:\sethc.exe file back to c:\windows\system32\sethc.exe.
Jul 14, 2012 | Toshiba Satellite A205-S5803 Notebook
Dec 27, 2010 | Acer TravelMate 2300 Notebook
May 08, 2010 | Cell Phones
Oct 21, 2008 | JVC Everio G Camcorder
Apr 29, 2008 | Computers & Internet
Sep 19, 2007 | Computers & Internet
Jun 10, 2017 | IBM Computers & Internet
589 people viewed this question
Usually answered in minutes!