topic Re: SAS JDBC Database Returns plenty of blanks as comment/label in Developers

SAS JDBC Database Returns plenty of blanks as comment/label

SebStu — Thu, 23 Sep 2021 07:36:26 GMT

Hi!

We try to use the JDBC Driver to view tables in a database viewer from Jetbrains (Data Grip, Pycharm, Intellij).

Driver: SAS Drivers for JDBC | SAS Support

Situation

We connected a SAS Dataservice with PyCharm (and other IDEs Intellij, DataGrip from Jetbrains) succesfully.
All tables and column information in the database tool tab looks fine….
But, if we open a table, the column name on all culomns is "<anonymous>"
Only Columns with a given comment/label will show the comment text.
Checking the DDL we found out, that each column without a comment has a plenty of blanks as a comment 😥

Anyone have seen this behaviour? Ideas to fix it?

We realy not want to copy the column name in all columns mandatory.😂

Column defintions of sashelp.cars

Table View with column names shows as "anonymous"

Responding Metadata vom SAS JDBC, see the many blanks as comment (sas called 'label')

DDL Created based on responding Metadata

Parallel Jetbains Issue

Database Table Colum Name "<anonymous>" instead Colum Name : DBE-14103 (jetbrains.com)

Re: SAS JDBC Database Returns plenty of blanks as comment/label

ballardw — Wed, 22 Sep 2021 16:45:47 GMT

It would likely be helpful to include the LOG from running the code reading the data source. Copy the text of the code and all messages from the code generating the data set from the LOG and paste the text into a text box opened on the forum with the </> icon appearing above the message window on the forum.

The text box is important as it will preserve the formatting of the text which often includes diagnostic information that gets reformatted when pasting into a code box.

If you are going to post pictures you need to explain why each image is posted and what we should be looking for and likely what program you are using to examine this. How are you "opening the table"? Also which SAS environment are you working in? On Demand, Enterprise Guide, or something else.

Re: SAS JDBC Database Returns plenty of blanks as comment/label

Tom — Wed, 22 Sep 2021 17:13:57 GMT

No idea what a "comment" is.

But it is perfectly normal to not attach a LABEL to a variable. For example that last photographs looks like it might be the SASHELP.CARS sample dataset that ships with SAS. Only some the variables have labels or formats attached to them.

What most SAS procedures that use the LABEL in the output instead of the NAME will do is use the NAME when the LABEL is empty.

As to the blanks remember that SAS has only two types of variables. Fixed length character strings and floating point numbers. It appears that whatever is populating the "comment" is taking the value of the LABEL field and including the trailing blanks that are included to pad it out to its full storage length.

Re: SAS JDBC Database Returns plenty of blanks as comment/label

SebStu — Thu, 23 Sep 2021 07:29:46 GMT

Hi! I am using the linked SAS JDBC driver in PyCharm, so there is no SAS Log.

Re: SAS JDBC Database Returns plenty of blanks as comment/label

SebStu — Thu, 23 Sep 2021 07:31:34 GMT

Many true words, but:

Issue descripes responding data with SAS JDBC driver

Re: SAS JDBC Database Returns plenty of blanks as comment/label

SebStu — Mon, 27 Sep 2021 07:05:23 GMT

@Kitara @kitara may you can help me? Are you using SAS JDBC on intellij?