需要帮助才能从AS400系统中获取数据 [英] Need help to get data out of an as400 system

问题描述

我有很多表和数据库.大多数表都具有空格，没有表col具有描述性的名称..有人可以帮助我从那里获取数据吗?谢谢

I have a plenty of tables and databases. most of the tables have empty spaces and no table col has a descriptive name.. can somebody help me to get the data out of there? thanks

推荐答案

看看出于文档目的，此处是关键信息.

For documentation purposes here is the key information.

如果您需要搜索一个字段或一个文件，请在SQL上遵循以下代码:

If you need to search one field or one file, follow this code on SQL:

Select * from Syscolumns

或

Select * from Systables

我相信特定的库是QSYS2.

更新以添加F.R.O.G.的路线:

1. 连接到服务器.
2. 在DB2选项卡上，选择File | File.新功能.
3. 在中间窗格中，输入您的SQL语句. Select * from QSYS2.Syscolumns where table_schema = 'LIBRARY'
4. 按Enter
5. 该语句将运行.根据需要缩小结果范围.
6. 获得所需结果后，可以右键单击底部窗格，然后从那里查看选项.

1. Connect to your server.
2. On the DB2 tab, choose File | New.
3. In the middle pane, enter in your SQL statement. Select * from QSYS2.Syscolumns where table_schema = 'LIBRARY'
4. Press Enter
5. The Statement will run. Narrow your results as needed.
6. Once you get the results you want, you can right click on the bottom pane and see your options from there.

这篇关于需要帮助才能从AS400系统中获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！