statement to count files in a folder strukture

[Former Member]

Hello,

i need a sql statement to count files in a folder strukture

this should be the result Startpath is users Folderpath ;Filecount /Users/miller ; 5 Files /Users/miller/test ; 20 Files /Users/smith/ ; 664 Files

[Former Member]

sorry, i need a DQL (like SQL) skript with direct output without a file.

[VolkerBarth]

I don't understand your point:

Both suggestions offer a SQL statement to build a normal result set (and with directory access servers, you will need some more statements to set up the according proxy table, as Reimer has shown). They don't output to a file.

---

In case your question doesn't deal with SAP Sybase SQL Anywhere but with PHP/Doctrine/DQL, then I guess you're asking in the wrong forum...

[reimer_pods]

Have a look at "Directory access servers" SA12 DCX. Using CREATE SERVER, CREATE EXTERNLOGN and CREATE EXISTING TABLE you will be able to scan the folder (and subfolders, if specified). Example:

CREATE SERVER "FolderSample" CLASS 'DIRECTORY' USING 'ROOT=C:/Users;SUBDIRS=1;CREATEDIRS=NO;READONLY=YES';
CREATE EXTERNLOGIN "dba" TO "FolderSample";

CREATE EXISTING TABLE "sirius"."UserDir" (
    "permissions" VARCHAR(10) NOT NULL,
    "size" BIGINT NOT NULL,
    "access_date_time" "datetime" NOT NULL,
    "modified_date_time" "datetime" NOT NULL,
    "create_date_time" "datetime" NOT NULL,
    "owner" VARCHAR(20) NOT NULL,
    "file_name" VARCHAR(260) NOT NULL,
    "contents" LONG BINARY NOT NULL
) AT 'FolderSample;;;.';

select file_name from UserDir where file_name like '%.csv'

[VolkerBarth]

When using SA 16, you would prefer to use the brand new Directory and file system procedures, particularly the sp_list_directory system procedure.