首页 \ 问答 \ 如何使用Netezza NZSQL中的制表符分隔符输出文件(How to output a file using tab delimiter in Netezza NZSQL)

如何使用Netezza NZSQL中的制表符分隔符输出文件(How to output a file using tab delimiter in Netezza NZSQL)

 我试图使用NZSQL CLI输出一些文件但不能输出为制表符分隔文件。 在新西兰工作过的人可以分享你对下面这个命令的想法。  
 到目前为止尝试： -  
nzsql  -o sample.txt -F=  -A -t -c  "SELECT * FROM DW_ETL.USER WHERE datasliceid % 20 = 2 LIMIT 5;"

I am trying to output some files using NZSQL CLI but not able to output as tab delimited files. Can somebody who has worked on NZ share your thoughts on this below command.  
Tried so far :- 
nzsql  -o sample.txt -F=  -A -t -c  "SELECT * FROM DW_ETL.USER WHERE datasliceid % 20 = 2 LIMIT 5;"

原文：https://stackoverflow.com/questions/30251399

更新时间：2022-06-08 11:06

最满意答案

 我想到了！ 将模型导入VS时，右键单击模型，转到属性并确保为Content Processor设置了“SkinnedModelProcessor”。  
 而已！  
 干杯 

I figured it out! When you import your model into VS, right click on your model, go to properties and make sure that "SkinnedModelProcessor" is set for Content Processor. 
That's it! 
Cheers

如何使用Netezza NZSQL中的制表符分隔符输出文件(How to output a file using tab delimiter in Netezza NZSQL)

最满意答案

相关问答

TCP/IP模型是一个________。[2023-10-02]

下列中不属于面向对象的编程语言的是?[2022-05-30]

双击选择标记的事件。(Double click event for a select tag. issue with Firefox)[2022-03-29]

嵌套的EJS标签。(nested EJS tag. Not working)[2023-05-13]

No Facebook!

遇到没有匹配开始标记的结束标记“tr”。(Encountered end tag “tr” with no matching start tag. Are your start/end tags properly balanced?)[2021-10-07]

程序检查图片框是否为空以及是否有标记。(Procedure is checks if picturebox is empty and if it has tag. Not working properly)[2022-04-29]

“此模型不包含SkinningData标记。”例外(“This model does not contain a SkinningData tag.” exception)[2022-03-09]

使用ArrayAdapter和标记。(Using ArrayAdapter and tag. Null Pointer exception)[2022-04-24]

格式错误的开始标记。(Malformed start tag. Attributes should be separated by whitespace.)[2021-11-14]

html：正确添加var标记的定义。(html: Correctly add a definition for a var tag.)[2021-11-19]

相关文章

最新问答