Search found 190 matches

by dpavlis
Fri Jan 22, 2021 11:21 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pass Metadata and Filename as Parameter in Designer
Replies: 12
Views: 11586

Re: Pass Metadata and Filename as Parameter in Designer

Hi Paul, Understand your situation. The problem with RunGraph executed from Designer (with "separate JVM" switched on) is that Clover ends up executing a totally independent process at your operating system level. Thus, it has no idea that there is some other CloverDX transformation runnin...
by dpavlis
Thu Jan 21, 2021 9:29 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Pass Metadata and Filename as Parameter in Designer
Replies: 12
Views: 11586

Re: Pass Metadata and Filename as Parameter in Designer

Hi Paul, Not sure what are you trying to achieve. If you would like the transformation graph executed in the separate JVM to log info into a specific file then you can use "Log file URL" parameter of the RunGraph component. The "-P:" command line parameter is not for JVM but for ...
by dpavlis
Mon Oct 19, 2020 9:34 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Memory/Space Estimating Tool?
Replies: 3
Views: 7975

Re: Memory/Space Estimating Tool?

Hi,

Since it looks like you are using CloverDX Server then TEMP space configuration options are available in our documentation.
by dpavlis
Thu Apr 02, 2020 1:33 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Pass Metadata and Filename as Parameter in Designer
Replies: 12
Views: 11586

Re: Pass Metadata and Filename as Parameter in Designer

Hello Paul, If you define a parameter in your parent graph (where you RunGraph component is) and then define the same parameter (name) in your child graph, then there is a way to pass the value of parameter from parent graph to child. You can use property "Graph parameters to pass" (multip...
by dpavlis
Wed Apr 01, 2020 12:26 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Handling str2date() Error
Replies: 3
Views: 2617

Re: Handling str2date() Error

Hello Paul, Can't really answer that.. would need to see the whole transform() & transformOnError() function you have. In general, onError() is called when exception is raised in transform(). If your transformOnError() returns SKIP (constant), then current record is skipped and processing contin...
by dpavlis
Tue Mar 31, 2020 2:52 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Handling str2date() Error
Replies: 3
Views: 2617

Re: Handling str2date() Error

Hi Paul, There are 2 options, how to handle it. One works only with the newest CloverDX release (5.6), the second even in older versions. But both should be used in interpreted mode of CTL. Option 1: try-catch (since CloverDX 5.6. ) date mydate; try{ mydate = str2date( ... params...); .. some other ...
by dpavlis
Thu Mar 26, 2020 6:29 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Pass Metadata and Filename as Parameter in Designer
Replies: 12
Views: 11586

Re: Pass Metadata and Filename as Parameter in Designer

Hi Paul, This is exactly what Server and JobFlow components are good for. If you need this to work in Designer without Server then you need to use parameters (external parameter file) and re-create the content of the parameter file each time with new values before you run the child graph. There is a...
by dpavlis
Thu Mar 26, 2020 6:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Clear Persistent Lookup
Replies: 6
Views: 9231

Re: Clear Persistent Lookup

Hi Paul, There is (unfortunately) no clear/direct way to remove all entries from Persistent Lookup Table. Your approach is what we would recommend - see this picture & notice the different phases of components: image.png However there might be a different way to accomplish what you are trying to...
by dpavlis
Fri Jun 14, 2019 10:47 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CloverDX 5.2.0 - Too many open files
Replies: 3
Views: 3400

Re: CloverDX 5.2.0 - Too many open files

Please, contact CloverDX support directly - at [email protected] as they may need additional info to solve this for you.
by dpavlis
Fri Jun 14, 2019 10:44 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Sequence with leading zeros
Replies: 2
Views: 2971

Re: Sequence with leading zeros

Well, sequences in Clover are numbers, what you are describing is a string representation. You might use function like this to format your sequence number to format you described: function string formatNum(integer num){ string fmstr=toString(num); return left("00000000",8-length(fmstr))+fm...
by dpavlis
Fri Jun 16, 2017 10:53 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Compare data does not get all data
Replies: 2
Views: 3868

Re: Compare data does not get all data

It looks like you are comparing not numbers, but strings - you have your variables defined as string variables. When comparing strings, you get "100" lover than "90" simply because it looks at the first chars of each string "1" & "9" in this case and decid...
by dpavlis
Fri Jun 16, 2017 10:43 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Partition Component
Replies: 3
Views: 4587

Re: Partition Component

Just a small note: Partition component does assign the filtered records to the output ports randomly when using the Partition key That is not really true. In fact the Partition component in that case (partition key defined) calculates a HASH of that key (which is a 32bit number) and then based on th...
by dpavlis
Tue Aug 30, 2016 10:37 am
Forum: CloverDX (formerly CloverETL) Support
Topic: find matching characters in 2 strings
Replies: 1
Views: 2792

Re: find matching characters in 2 strings

Hi, the first can be done somehow like this in CTL: string str1; string str2; string target; for(integer i=0;i<lenght(str1);i++){ string letter=charAt(str1,i); if (contains(str2,letter) target=target+letter; } Basically I go through individual letters/characters of str1 and check whether they are in...
by dpavlis
Thu Aug 25, 2016 1:20 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CTL Template
Replies: 1
Views: 2708

Re: CTL Template

Hi,

You may find import statement of CTL2 useful for this.
by dpavlis
Thu Aug 25, 2016 1:16 pm
Forum: CloverDX Server
Topic: DDL for CloverETL server database setup
Replies: 5
Views: 7790

Re: DDL for CloverETL server database setup

Hi, One creative idea. Why don't you let CloverETL Server create all the necessary Oracle DB objects on some test instance of DB (or just schema). Then your DB admin can a) analyze that it does not contain anything dangerous b) just clone/copy all the tables and DB objects into the production DB. Th...

cron