Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need to get File Creation Date from Mainframe

cetricelaens
7 - Meteor

I was downloading one file from Mainframe via Download Tool using ftp properties I have given. While downloading I need to get file creation date in Mainframe ? Actually I already getting File referred date.

Below was the sample I was getting as of now

 

Volume Unit   Referred   Ext Used Recfm Lrecl BlkSz Dsorg Dsname
TST090 3390 2019/09/11 4 134 VB 2000 27998 PS G0060V00
TST269 3390 2019/09/11 5 140 VB 2000 27998 PS G0061V00
TST358 3390 2019/09/11 4 135 VB 2000 27998 PS G0062V00
TST185 3390 2019/09/12 5 138 VB 2000 27998 PS G0063V00
TST341 3390 2019/09/12 5 138 VB 2000 27998 PS G0064V00

 

3 REPLIES 3
DiganP
Alteryx Alumni (Retired)

@cetricelaens You can use the download tool with the GET request to get a list of all the files. Once done, you can sort the files based on date modified and join with the actual file based on the file name. 

Digan
Alteryx
cetricelaens
7 - Meteor

Yeah via GET request and Download only , I got below data. But If you can see am just getting Referred Date but need Creation Date.

 

Volume Unit   Referred   Ext Used Recfm Lrecl BlkSz Dsorg Dsname
TST090 3390 2019/09/11 4 134 VB 2000 27998 PS G0060V00
TST269 3390 2019/09/11 5 140 VB 2000 27998 PS G0061V00
TST358 3390 2019/09/11 4 135 VB 2000 27998 PS G0062V00
TST185 3390 2019/09/12 5 138 VB 2000 27998 PS G0063V00
TST341 3390 2019/09/12 5 138 VB 2000 27998 PS G0064V00

danilang
19 - Altair
19 - Altair

Hi @cetricelaens 

 

You can only retrieve columns that the FTP server includes in the directory listing.  The configuration options to change the list of columns varies by FTP server, so you'll have to research the specific FTP server your calling to see if there's some way to add the created date to the returned columns

 

Dan

Labels