table_name写入格式为\ dc的疑问

2020-08-16 00:46发布

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


如何用\ dc 解释以下现象?

从" LIUYL_BAK"中选择*。" baktest1_catlog";

| BACKUP_ID | DESTINATION_PATH | | -------------------- |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_2_1 |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_3_1 |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_0_1 |

已选择3行(总时间1704.078毫秒;服务器时间1013微秒)

\ dc" LIUYL_BAK"。" baktest1_catlog"

找不到匹配的搜索模式:%.LIUYL_BAK

hdbsql BK1 =>

\ dc LIUYL_BAK.baktest1_catlog

找不到匹配的搜索模式:LIUYL_BAK.BAKTEST1_CATLOG

hdbsql BK1 =>

\ dc LIUYL_BAK。" baktest1_catlog"

表" LIUYL_BAK.baktest1_catlog"

| 列名| 类型 伦| Nul | 关键

| BACKUP_ID | BIGINT | 19 | 否| 不适用

| DESTINATION_PATH | VARCHAR | 512 | 是的 n/a |

hdbsql BK1 =>>

>> \ dc" LIUYL_BAK.baktest1_catlog"

找不到匹配的搜索模式:%.LIUYL_BAK.baktest1_catlog

hdbsql BK1 =>>>

\ dc SYS.P_PSES_

表" SYS.P_PSES_"

列名,类型,长度,可空,键位

" ID"," BIGINT"," 19"," NO"," n/a"

" NAME"," NVARCHAR"," 256"," YES"," n/a"

"目的"," TINYINT"," 3","否","不适用"

"所有者"," BIGINT"," 19","否","不适用"

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


如何用\ dc 解释以下现象?

从" LIUYL_BAK"中选择*。" baktest1_catlog";

| BACKUP_ID | DESTINATION_PATH | | -------------------- |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_2_1 |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_3_1 |

| 1592362328179 |/usr/sap/BK1/HDB10/backup/data/COMPLETE_DATA_BACKUP_databackup_0_1 |

已选择3行(总时间1704.078毫秒;服务器时间1013微秒)

\ dc" LIUYL_BAK"。" baktest1_catlog"

找不到匹配的搜索模式:%.LIUYL_BAK

hdbsql BK1 =>

\ dc LIUYL_BAK.baktest1_catlog

找不到匹配的搜索模式:LIUYL_BAK.BAKTEST1_CATLOG

hdbsql BK1 =>

\ dc LIUYL_BAK。" baktest1_catlog"

表" LIUYL_BAK.baktest1_catlog"

| 列名| 类型 伦| Nul | 关键

| BACKUP_ID | BIGINT | 19 | 否| 不适用

| DESTINATION_PATH | VARCHAR | 512 | 是的 n/a |

hdbsql BK1 =>>

>> \ dc" LIUYL_BAK.baktest1_catlog"

找不到匹配的搜索模式:%.LIUYL_BAK.baktest1_catlog

hdbsql BK1 =>>>

\ dc SYS.P_PSES_

表" SYS.P_PSES_"

列名,类型,长度,可空,键位

" ID"," BIGINT"," 19"," NO"," n/a"

" NAME"," NVARCHAR"," 256"," YES"," n/a"

"目的"," TINYINT"," 3","否","不适用"

"所有者"," BIGINT"," 19","否","不适用"

付费偷看设置
发送
4条回答
黑丝骑士
1楼-- · 2020-08-16 01:30

您好,
\ dc是从hdbsql提示符内部使用的,用于列出列,就像您在上面尝试过的那样。

在您的情况下,
\ dc" LIUYL_BAK"。" baktest1_catlog"->不起作用
,但
\ dc SYS.P_PSES_ ==>可以。

因此,您使用的格式是绝对正确的,而问题在于授权。

用于登录到" hdbsql"提示符的用户需要访问从" LIUYL_BAK"的架构所有者读取的权限。 提供访问权限后,它将可以使用。

最好的问候,
Vivek Sahu

追夢秋陽
2楼-- · 2020-08-16 01:27

您问了一个问题。 不要忘记将对您最有帮助的答案标记为正确。 谢谢!

对于读者而言,在您离开之前,请不要忘记对答案进行上下投票。 您也可以对这个问题进行投票。
谢谢!

宇峰Kouji
3楼-- · 2020-08-16 01:43

内核版本:2.00.041.00.1560320256

SQLDBC版本:libSQLDBCHDB 2.04.142.1559148247

所以这真的很奇怪!!

>

>

> \ dc" LIUYL_BAK.Employee"

找不到匹配的搜索模式:%.LIUYL_BAK.Employee

hdbsql BK1 =>>>> \ dc LIUYL_BAK.Employee

找不到匹配的搜索模式:LIUYL_BAK.EMPLOYEE

hdbsql BK1 =>

>

>

> \ dc LIUYL_BAK。"员工"

表" LIUYL_BAK.Employee"

列名,类型,长度,可空,键位

" [Emp_ID]"," INTEGER"," 10","是","不适用"

" [Dept_ID]"," INTEGER"," 10"," YES"," n/a"

" [开始日期]","时间戳"," 27,7","是","不适用"

" [结束日期]","时间戳"," 27,7","是","不适用"

hdbsql BK1 =>

>

>

> \ dc" LIUYL_BAK"。"员工"

找不到匹配的搜索模式:%.LIUYL_BAK

hdbsql BK1 =>>>

大简至美
4楼-- · 2020-08-16 01:32

您好,
我检查了没有模式名称的表,它也能够检测到它。

hdbsql XYZ => \ dc DDNTF(正常工作)
hdbsql XYZ => \ dc SAPABAP1.DDNTF(正常工作) hdbsql XYZ => \ dc SAPABAP1。" DDNTF"(正常工作)
hdbsql XYZ => \ dc" SAPABAP1" .DDNTF(找不到匹配,双引号在schema_name中不起作用)
hdbsql XYZ => \ dc" SAPABAP1"。" DDNTF"(找不到匹配项,双引号在 schema_name)

如果仍有疑问,请提及hdbsql版本,以及用于登录hdbsql的用户特权。
最好的问候,
Vivek Sahu

一周热门 更多>