DSXchange

Little update on this problem fixed by IBM:

This case is referenced as "APAR JR39895" and IBM produced a patch for it in v8.1 FP1 (it seems that it is corrected in FP2, but I can't tell).

https://www-304.ibm.com/support/docview ... wg1JR39895

Update on this thread : I've opened up a PMR at IBM, which reference is JR42593. They have produced a patch for v8.1 which fix the error even if I still don't get any result from the "check -table" and "check -query" command. I will update again this thread when I will have IBM a...

Personally, I only use partitioned reads on huge tables, after a good talk with a dba to ensure that opening N sessions running the query won't affect the source DB negatively and to validate the query/indexes/hints used. You could actually import data using a round-robin partition algorythm and imm...

Hi, From my experience (on Oracle source) : The type of parallelism in database source depends on how you configure it (enable partitioned reads). => round robin on rowid / Hash on rowid / modulus on numeric column / database partitionning. For example, if you use rowid hash partitionning on a 2 nod...

Hi,

I got the exact same problem on 2 distant servers (RDP) which are xp and server 2003. They have 6GB and 12GB of ram on each.
Another 2003 server with 6GB of ram is displaying well my stage properties. Clients are installed with the same version.

Eric

Hi, For the record, I managed to get the diff tool working by changing my current dir to the diff one :D Final code is as follow : cd %PATH% %Cmd% /lhscd "/D=%DomainL% /H=%HostL% /U=%UserL% /P=%PasswordL% %HostL%.app.loc/%ProjectL% %JobLeft%" /rhscd "/D=%DomainR% /H=%HostR% /U=%UserR%...

Hi,

I don't know if it's the same error as mine (topic here) since you're talking about diffguicomparer and I about diffapicmdline (which should be underlying diffguicomparer), but I've opened a PMR and I'm waiting for IBM answer.
I will let you know if I can run this tool.

Regards,
Eric

Hi all, I'm facing a strange problem using XML Input stage. A value contains two special characters CR/LF coded via xml 1.0 white space convention : - 
 for CR - 
 for LF The LF char works fine while CR aborts xml import, giving back the following warning : XML_PXML_PRJ,0: Warning: J...

Hi,

Did you try to set the path in an environment variable that you can call directly or set in a parameter set?
If I'm not wrong, for each modification of the routine (as I recall code change and also for path change) you have to recompile all jobs depending on it.

Eric

Hi,

You can use file pattern like said before, or use a bash command in the file pattern expression to read your configuration file and pass through files names.

Eric

Hi, I've already done this using a logic as following: - In sequence job, detect your delimiter and other properties - Optionally call either a command line, script or job to modify a template schema file properties (delim_string='#Your Char#') - Then run you job using the correct schema file passed...

You might take a look at xmeta table ASCLMODEL_USERB1C497CE (or like so) On oracle: select table_name from all_tables where table_name like 'ASCLMODEL_USER%' then select PRINCIPALID_XMETA, LASTNAME_XMETA, FIRSTNAME_XMETA from ASCLMODEL_USERB1C497CE I didn't figure out how to relate users to projects...

Kryt0n wrote:Makes the second step fairly pointless, if it converts, it clearly is valid

Sure, but one might want to have a reject rather than an abort if data doesn't match the format string during conversion. A px routine can recreate the v8.5 behavior of the isValid function.

Hi, I believe that in 8.0 and 8.1 there is no possibility to give a format string for date validation. You can do it in two steps : transform string into date, and then validate the date using isvalid. The problem is that if your string does not match the format string in the stringtodate function, ...

Hi,

I face the same issue using the 8.1. As the note in this APAR, you should install fix pack 1 for v8.5, or the JR37268 patch (if available for 8.5). It might then correct the bug

Regards,
Eric