| mpcsmits |
| Advanced Member |
| Mark Smits |
| NL |
|
|
| None Specified |
|
| Tuesday, August 17, 2004 |
| Thursday, March 21, 2013 2:08:44 PM |
149
[0.82% of all post / 0.02 posts per day] |
|
I just noticed that the email address in my profile is a real old one which, as far as I know, doesn't exist anymore. I cannot change the address, when editing my profile. It's grayed out. How can I change it?
|
Is anyone using any Altova product (so not only DatabaseSpy but also MapForce and/or XMLSpy and/or ...) to access the iSeries physical and logical files.
If so, are you connecting through ODBC, ADO or JDBC?
If connecting through ADO, can you show me a working connection string to access any library? I can't seem to get the connection string right. It always shows me a library equal to my username without the possibility to change that. If I login as MARK, I get a library MARK to explore. If I login as OFFICERMAR, I get a library OFFICERMAR to explore. Regardles of what properties I set the collection or library list parameters to.
If connecting through JDBC, are you using the as400 protocol (toolbox) or the db2 protocol (db2jcc). If using the db2 protocol, can you tell me the connection URL you are using. I can't get the latter to work.
Has anyone been able to get primary keys out of physical files and/or indices out of logical files (with the help of DatabaseSpy or by generating a scheme using XMLSpy using any of the connection possibilities? If so, can you guide me though the process?
Thanks,
Mark
|
Has anyone been able to connect to the iSeries using ADO. There are some defaults to fill in like library list, default collection or whatever parameter.
No matter what combinations or values I try, I can't connect to the correct library. I need to connect to library ABC, but when establishing the connection, the only visible "library" is a library named MARK which is equal to my username. There is not even a library MARK on the system. It is also not possible to select another libary. Like I am able to do when using ODBC.
Unfortunately the requirement is ADO. Can anyone help me out here?
|
It all depends on the language settings you are using in your mapping (and which version of MapForce, don't know exactly when xlsx support was introduced)
XSLT: Sorry...
XSLT2: current-dateTime and datetime-to-xslx function
XQuery: For some reason the xlsx functions are not available here...
Java, C#: now and datetome-to-xlsx function
C++: Again xlsx functions not available
|
What subversion of MySQL 5.0 is that ? I had a similar problem when trying to insert records on a 5.0 database with a third party ODBC driver. After updating 5.0 to a more recent version all my problems went away. To be more specific, the old version was 5.0.67 and after upgrading to 5.0.81 my problem was gone.
Also, the stacktrace shows a castToString. Are you sure the types of the source and target field are the same. And/or are you sure the field value of the particular order is not NULL ?
|
The target is an interger and the source is a decimal in scientific notation. It will just try to put the source value into the target and based on types may try to do some conversion. When converting the value it just doesn't take the value in front of the decimal point and make that the integer value. When trying to covert to integer it discovers a ".", a "E" and a "-" and complains about extra characters that are not numeric. You will need one of the functions round, floor or ceiling, eliminating the scientific notation.
|
Regarding XLS. You can try the MS supplied ODBC driver to connect to XLS. We have had some success reading XLS this way. Much depends on how simple/complex the XLS is defined.
|
XSLT2 en XQuery do have a matches function. Java and C# do have a match-pattern function. These functions can be used to compare string against a regular expression.
I can't fnd such functions in the XSLT or C++ library.
|
Again, use AltovaXML :) See https://www.altova.com/download_components.html.
A quote from that page:
Quote:AltovaXML includes COM, Java, and .NET interfaces so that it can be used from a variety of different applications...
|
When viewing the output of the intermediate file, save this. There should be a button for it in the toolbar or select it from the menu.
Then go back to the mapping, select the properties of this intermediate object and set the input instance to the file you just saved. Then look at the output of the final file.
This only needs to be done within MapForce. The generated source will do the entire mapping at once.
|
|
