ACIF and historical loads

Previous topic - Next topic

DDEVENPORT

I am using ARSLOAD for Windows loading AFP documents using TLEs through the ACIF Indexer. We just pass the content as an ARD file.

I added a POSTING_DATE TLE formatted as %Y%m%d%H%M%S and passing 20170704010101 in the TLE.

ARS1129E Row 1:  The string "20170704010101" could not be converted to a date from the format of %Y%m%d%H%M%

What I am trying to accomplish is setting a POSTING_DATE in the past. My application would pass the date we want in the TLE and not use the system date timestamp. Bad assumption on my part that this would work?

If I can't manage POSTING_DATE this way, what would be the correct way? I cannot find documentation. The preference would be to manage this with the content data (TLE).

Justin Derrick

You're missing the seconds parameter (%S?) in the ACIF indexing parameters.

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

DDEVENPORT

Thanks for the reply.

In this case no, not missing.

Discovered that the TLE 'data' has a trailing hexadecimal '0D'. I changed that in the data to a space hexadecimal '40' and added that to the trailing character removal and it worked then.

The annoyance with this is, the error message does not 'display' the extraneous data leading you to believe that WYSIWYG(GOT) and it isn't. Another annoyance is trying to get that X'0D' removed through the CHARACTER REMOVAL GUI. Could not figure out how to do that.

Anyway, having our client application remove the offending data.

Justin Derrick

Quote from: DDEVENPORT on July 28, 2017, 12:54:07 PM
Anyway, having our client application remove the offending data.

Yeah, the best way forward is to have data that is correct and compliant.  :)

Thanks for posting the solution to your issue! 

-JD.
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Webinars:  https://CMOD.Training/
IBM CMOD Professional Services: https://CMOD.cloud

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR