Question about IBM Computers & Internet

Open Question

Copy a CSV file to an AS/400 flat file using CPYFRMIMPF.

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.

Thanks,
Shipit

Posted by on

Ad

3 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
Goodluck!

Posted on Jan 02, 2017

Ad
  • 189 Answers

SOURCE: how to delete, copy and rename obtained output file

write a batchfile .bat.
put all commands inside notepad and save as .bat
this will help.

Rate me Rate me

Posted on Mar 24, 2009

Ad
  • 62 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How do i do a factory reset on my toshiba satellite a100 laptop?? I havent used it in over a year and have forgotten my password and simply want to reset it. But the forums i read everywhere have not...


Unfortunately you need to have an installer of the windows. If you do not have a recovery dish I suggest you download the ISO of windows 7 from here: http://www.w7forums.com/threads/official-windows-7-sp1-iso-image-downloads.12325/ and then burn it on a DVD to make an installer disk. Then insert this disk in the computer you need to reset 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
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.
hat'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.

Regards
David

Sep 18, 2013 | Computers & Internet

Tip

How can I run two Skype accounts on the same computer?


To use more than one Skype account on the same computer at the same time you need to start a new instance of Skype.
1.
From the Windows taskbar, click Start > Run (or press the Windows and R keys on your keyboard at the same time)
2.
In the Run window, enter the following command (include the quotes) and press OK:
"C:\Program Files\Skype\Phone\Skype.exe" /secondary
If you get an error message, copy and paste the exact command from this page and try again.
Be aware that if you have changed the installation path for Skype then you will need to enter the correct path for the Skype.exe file.
If this solution fails, you can try another option:
1.Find the Skype executable file (Skype.exe) in: C:\Program Files\Skype\Phone\
2.Right click on it and select Send to > Desktop (create shortcut)
3.Locate the shortcut on the desktop, then right-click on it and select Properties
4.In the Target field, add: /secondary. The Target field should now be "C:\Program Files\Skype\Phone\Skype.exe" /secondary
5.Click OK. You can now start a new instance of Skype every time you double-click the new shortcut.

on Nov 19, 2013 | SKYPE Computers & Internet

1 Answer

When I turn my netbook on it starts loading then prompts for "Current password", After typing the incorrect password in screen dispays "system will now HALT"


Seems you have forgotten your password you need to rest it. Unfortunately you need to have an installer of the windows if you do not have a recovry disk. If you do not have a recovery dish I suggest you download the ISO of windows 7 from here: http://www.w7forums.com/threads/official-windows-7-sp1-iso-image-downloads.12325/ and then burn it on a DVD to make an installer disk. Then insert this disk in the computer you need to reset 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
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.
hat'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.

Sep 18, 2013 | Computers & Internet

2 Answers

User password


Resetting Your Forgotten Windows Password

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.

source: http://www.howtogeek.com/?post_type=post&p=96630

Jul 14, 2012 | Toshiba Satellite A205-S5803 Notebook

1 Answer

Configure.csv


CSV means:
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.

Dec 27, 2010 | Acer TravelMate 2300 Notebook

1 Answer

My final objective is to copy my contacts and messages in my Nokia E66 (with a symbian OS) to my new HTC Legend with an Android 2.1 OS. To do this i have devised the following way - 1) Using Nokia PC...


There could be two problems first once you used comma separated values spaces in contact names are definetly going to occur that is going to ruin the file. This approach is entirely not recommended. Secondly if the file while copy has triggered any event in the OS that will be unavailable and would be shown under using category. Hence, first hit ctrl + alt + del open processes tab right click processes and select end process tree wait for 10 seconds click on first tab and click new task command button and type explorer and ok. Now try to import the contacts in outlook. I'm providing this so you can do this with your own method. There are many more methods to achieve the same. Kindly let me know if this does not works.

May 08, 2010 | Cell Phones

2 Answers

Dos commands in linux


go to http://www.pctechguide.com/articles/gettingDedicated12.htm you will find all the commands you need in there.

Jun 01, 2009 | Microsoft Computers & Internet

1 Answer

MOD file


The MOD file is just MPG format,
a simple MS-DOS command line instruction to rename your MOD files to MPG files (first copy your camcorder-harddisk files to PC-harddisk). I use to do the same!
Just execute the following command in the proper directory (or place this line in RENAME_MOD2MPG.BAT, and execute BAT file by doubleclick); the command assumes the JVC 3hexa-digit method of numbering:

ren MOV???.MOD MOV???.MPG

Oct 21, 2008 | JVC Everio G Camcorder

1 Answer

How do i reboot windows vista. i knwo theres a way to do it not from the CD and it returns it to how u go it out of the box. please let me know thanks


If you are using MS-DOS 6.0 or later, you can use multiple configuration menus or the CHOICE.COM program to configure your system. For more information on using these options under MS-DOS 6.0 or later, type HELP MULTI-CONFIG or HELP CHOICE at the MS-DOS command prompt and then press ENTER. To create the files to automatically restart your computer with the appropriate configuration, do the following:

Create a directory on your hard drive called C:\CONFIGS. Create the CONFIG.SYS and AUTOEXEC.BAT files you need to boot your system for HIMEM.SYS and applications that require it, with the following names: c:\configs\config.dos c:\configs\autoexec.dos Create the CONFIG.SYS and AUTOEXEC.BAT files you need to start your system for the program that conflicts with HIMEM.SYS. Any unique file extension can be used. The following example uses 386: c:\configs\config.386 c:\configs\autoexec.386 The following DEBUG script can be used to create a small executable file called REBOOT.COM. This file, when executed, will cause your system to restart. To create the file, change to the DOS directory, and type the following: debug reboot.comEnter the following information, pressing ENTER key after each line: A 100 ; Debug instruction for assemble MOV AH,0D ; Disk Reset INT 21h ; causes SmartDrv 4.x to write cache MOV AX, 40 ; set up segment addressing MOV DS,AX DS: OR BYTE PTR [17],0C ; equivalent of pressing CTRL+ALT MOV AX,4F53 ; Issue a "DEL" (53h = DEL scan code) INT 15h ; EMM386 sees this & shuts down. DS: MOV WORD PTR [72],1234 ; Set REBOOT flag to Warm-Boot (0=cold) JMP F000:FFF0 ; Execute the internal restart routine <CR> ; This line must be blank (just hit ENTER) R CX 20 ; File size to be written to disk (in hex) N REBOOT.COM ; Filename W ; Write the file to disk Q ; Quit Debug NOTE: The REBOOT.COM file created with this debug script is compatible with SMARTDrive and its write-behind cache feature. The instructions in REBOOT.COM cause SMARTDrive to write (flush) its write-behind cache to disk before the computer is rebooted.

The following commands can be used to copy and rename the configuration files to the root directory of the C drive and restart the computer. To simplify the process, you can put these commands into batch files.

To start your machine for Windows, use the following commands: copy c:\configs\autoexec.dos c:\autoexec.bat copy c:\configs\config.dos c:\config.sys reboot.com To start your machine for the 386 application, use the following commands: copy c:\configs\autoexec.386 c:\autoexec.bat copy c:\configs\config.386 c:\config.sys reboot.com

Apr 29, 2008 | Computers & Internet

2 Answers

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.

Sep 19, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

589 people viewed this question

Ask a Question

Usually answered in minutes!

Top IBM Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18407 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

Computer Links

Level 3 Expert

2385 Answers

Are you an IBM Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...