[Elijah Park]

Jim, I used both NLST and LIST with no success. I’ll get with the server guys. Appreciate the response.

Max, thanks for the code hookup. Well documented too. Suggestion: you might want to initialize variable “fileNames” in tps_dirparse_list_files.

[Elijah Park]

Any idea why I would be getting this in my message and not the {name size mtime} list or even a simple file list {file1 file2 file3} for that matter?

NLST

“DEBUG: fileList: File1

File2

File3

File4″

===============================================

LIST

“DEBUG: fileList: total 1880

-rw-r

---

   1 lawson   lawson        36115 Nov  9 09:46 File1

-rw-r

---

   1 lawson   lawson       886294 Nov  6 14:57 File2

-rw-r

---

   1 lawson   lawson        32241 Nov  6 14:57 File3

-rw-rw-rw-    1 lawson   lawson          237 Jan  9 2015  File4″

[Elijah Park]

We just upgraded to 6.1 this weekend and used SMAT DB right out the chute – we found searching across multiple files super helpful during testing.

The Java regex it uses takes a little getting used to. For example, if I wanted to search for an “&” after the PID segment and cross carriage returns, I would key this:

Code:

(?s)PID.*&

One question: Is there a way to run SQLite queries directly against the encrypted db files?

[Elijah Park]

@Jeff – I’m super interested in learning how you use TclODBC at your organization. Did you have to download a driver like freeTDS in order to make it work? Did this work in or out of the DNS? I’m on AIX.

Thx.

[Elijah Park]

Thanks Keith. That did the trick. 🙂

[Elijah Park]

Appreciate the help, guys. Our ncargs were already set to 256. However, as it turns out, we were in active mode. Switching to passive did the trick.

[Elijah Park]

Thanks Jim. I am sure I want to send “”. In order to accurately reflect what’s on the source system, I must delete the value on the target, especially if it’s an optional field on the source and has been removed.

I will take your advice and use my own proc to return an active null.

[Elijah Park]

NP Jim. I appreciate your feedback.

[Elijah Park]

Jim K, sounds like a neat idea…didn’t know you could set an FRL field to repeat.

Jim C, it works like a charm!

Thank you both.

[Elijah Park]

Lawrence, we are battling this very same issue. Only we’re running CL 5.6 on AIX 5.3.

After reading the log files and scratching our heads, we decreased LOGCYCLESIZE to 12500 thinking that would work. It didn’t.

Any ideas, Clovertechers?

[Elijah Park]

Thanks Jim for the quick, helpful response.

[Author]

Replies