可以在NT上卸载DB2（以记录顺序文件）吗？ [英] DB2 Unload (to record sequential file) on NT possible?
问题描述
我正在尝试将表中的DB2数据卸载到NT上的记录顺序文件
。我可以在Mainframe上卸载，但在NT中它似乎不是一个
选项。
在NT中，我所能做的就是导出/进口。我也可以做一个加载，但不是一个
卸载。我只想要记录
顺序文件中表中的唯一数据。导出似乎只是为了给出一个分隔的
行顺序文件或记录顺序文件的选项，其中数据是
，然后是表格设置信息。
那么有没有办法在NT上卸载数据？谢谢。
您可以尝试导出该表分隔，没有字符
分隔符和一个非常特殊列分隔符（导出到del
由nochardel修改的文件，coldel~select blablabla ...），然后查找和
将所有列分隔符替换为''nothing ''。虽然我不明白为什么
分隔文件不能像记录布局一样好用。它是
相同的数据，你只需要对它进行不同的再次导入即可。
使用一个小程序/脚本这应该很容易。
Timofmars写道：
我试图将DB2数据从表中卸载到记录中顺序文件
在NT上。我可以在Mainframe上卸载，但在NT中它似乎不是一个
选项。
在NT中，我所能做的就是导出/进口。我也可以做一个加载，但不是一个
卸载。我只想要记录
顺序文件中表中的唯一数据。导出似乎只是为了给出一个分隔的
行顺序文件或记录顺序文件的选项，其中数据是
，然后是表格设置信息。
那么有没有办法在NT上卸载数据？谢谢。
你的最终目标是什么？是否要在NT上运行的另一个DB2
实例中导入数据？尝试使用WinSQL
（ http://synametrics.com/winsql)。这个程序允许将数据从
一个源移动到另一个目标。
不，我不是要导入数据到另一个DB2实例。
相反，我们有一个COBOL程序，它读取导出的数据并从数据中创建
a VSAM备份文件。通常，它会直接从DB2表中读取数据
来创建备份。
然而，我创建的东西非常类似于他们的建议
我在分隔文件中导出数据并有一个COBOL程序
解析分隔符。这大约是直接从表中读取的方法的两倍。
但是不是继续使用分隔的导出数据，而是记录
顺序导出文件将是理想的。 UNLOAD命令适用于
大型机，但显然不在NT上。 IPX格式的NT选项
导出似乎是记录顺序，但有一个头文件
包含我不想要的列信息。我不能想到一个简单的方法来跳过或删除那些列数据。所以我只是在寻找一种方法来获得一个只有数据的纯记录顺序文件。
感谢您的答复到目前为止。
2月2日下午3:47，Juan Singh< j ... @ anonymous.comwrote：
Timofmars写道：
< blockquote class =post_quotes>
我试图将表中的DB2数据卸载到记录顺序文件中。
在NT上。我可以在大型机上卸载，但在NT中它似乎不是一个
选项。
在NT中，我所能做的就是导出/导入。我也可以做一个加载，但不是一个
卸载。我只想要记录
顺序文件中表中的唯一数据。导出似乎只是给出了一个选项，可以有一个分隔的
行顺序文件或记录顺序文件，其中数据是
，然后是表格设置信息。
那么有没有办法在NT上卸载数据？谢谢。
你的最终目标是什么？是否要在NT上运行的另一个DB2
实例中导入数据？尝试使用WinSQL
（ http://synametrics.com/winsql)。该程序允许将数据从
一个源移动到另一个目标。
I''m try to Unload DB2 data from a table into a record sequential file
on NT. I can an unload on Mainframe, but it doesn''t seem to be an
option in NT.
In NT, all I can do is export/import. I can do a Load too, but not an
Unload. I just want the only the data from the table in a record
sequential file. Export seems only to give options to have a delimited
line sequential file or a record sequential file where the data is
preceeded by table setup information.
So is there a way to unload data on NT? Thanks.
You could try exporting that table delimited , with no character
delimiter and a very special column delimiter (export to file of del
modified by nochardel, coldel~ select blablabla...), and then find and
replace all column delimiters by ''nothing''. Although I don''t see why a
delimited file couldn''t work just as well as a record layout. It''s the
same data, you just need to treat it differently to import back again.
With a little program/script this should be easy.
Timofmars wrote:I''m try to Unload DB2 data from a table into a record sequential file
on NT. I can an unload on Mainframe, but it doesn''t seem to be an
option in NT.
In NT, all I can do is export/import. I can do a Load too, but not an
Unload. I just want the only the data from the table in a record
sequential file. Export seems only to give options to have a delimited
line sequential file or a record sequential file where the data is
preceeded by table setup information.
So is there a way to unload data on NT? Thanks.
What is your end goal? Do you want to import data in another DB2
instance running on NT? Try using WinSQL
(http://synametrics.com/winsql). This program allows moving data from
one source to another target.
No, I''m not trying to import the data into another DB2 instance.
Instead, we have a COBOL program that reads exported data and creates
a VSAM backup file from the data. Normally, it would read data
directly from the DB2 tables to create the backup.
However, I''ve created something very similar to what andyhe suggested
where I export the data in a delimited file and have a COBOL program
parse out the delimiters. This is about twice as fast as the method of
reading directly from the tables.
But rather than continue using delimited export data, a record
sequential export file would be ideal. The UNLOAD command works on
Mainframe, but apparently not on NT. The NT option of an IPX format
export seems to be record sequential, but there is a header file
containing column information that I don''t want. I can''t think of an
easy way to skip over or remove that column data either. So I was just
looking for a way to get a pure record sequential file with only data.
Thanks for the replies so far.
On Feb 2, 3:47 pm, Juan Singh <j...@anonymous.comwrote:Timofmars wrote:I''m try to Unload DB2 data from a table into a record sequential file
on NT. I can an unload on Mainframe, but it doesn''t seem to be an
option in NT.
In NT, all I can do is export/import. I can do a Load too, but not an
Unload. I just want the only the data from the table in a record
sequential file. Export seems only to give options to have a delimited
line sequential file or a record sequential file where the data is
preceeded by table setup information.
So is there a way to unload data on NT? Thanks.
What is your end goal? Do you want to import data in another DB2
instance running on NT? Try using WinSQL
(http://synametrics.com/winsql). This program allows moving data from
one source to another target.
这篇关于可以在NT上卸载DB2（以记录顺序文件）吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
