DSXchange

Ah ... yep, everything I need is in the .dsx file. I see what you mean about having to backtrack -- I see a possible quick and dirty solution if I FTP the .dsx over to AIX and use grep from there to accomplish what I'm trying to do. I'm not sure I have the time and availability to go for the much mo...

Hi -- Is there a way to search for text within all sequence jobs in a project where we have DS (8x) installed on AIX? For example, I'm able to do a grep in /opt/IBM/InformationServer/Server/Projects/<ProjectName>/*SC*/*osh and I can find instances of where certain environment variables are used in p...

Thanks Andy -- I definitely appreciate any tips/hints/pointers as you work through the install with DS 8.7. Sounds like the Hyperion Pack isn't packaged with 8.7 either, and it's still an extra add-on install? You're right though, we are using Windows clients to connect to the DS server running on A...

Looks like I've solved this one -- I've learned to set the length of the character fields to twice as much as it seems like I would need, and I believe this is due to the double-byte characters that are present. So if I'm receiving a 100-character field, I actually need to define it as varchar(200),...

Thought I'd come back and close this one out -- we probably have hundreds of table definitions (not thousands) spread across 20 folders or so. I suspect this is related to our infrastructure and other network traffic occurring on the DS server. We're also moving to DS 8.7 in the coming months, and a...

I've searched the forum and have come up with a surprisingly small number of matches on the Essbase Pack for DS, how much experience is out there with installing and using this add-on for DS? We have DS 8.1.0.0 running on AIX, and from the information I've gathered, we could install the Hyperion Ess...

I haven't given up hope on this one yet, but did put a message handler in place to suppress the values that are coming in and failing, so I can at least load those values that don't have the error.

I'm definitely open to any and all new suggestions or ideas though!

I'm pulling in data from an AIX DB2 instance, and loading another iSeries DB2 instance, and am encountering warning messages that I have fragmented MBCS characters in the data. SQL0191N Error occurred because of a fragmented MBCS character. Invalid character(s) ([xE6][xA0]) found converting string (...

Compiles and saves are somewhat slow ... but waiting for the table list to come up to load metadata in a DB2 stage is the most exasperating delay.

Unfortunately -- the load of the table list is always slow, regardless of the time of day or activity on the system. I was hoping there might be a tweak of a configuration file I could make, or is it possible our metadata catalog has hit some limit of data impacting performance of loading the list?[...

Is there normally a long delay (2 to 3 minutes?) while waiting for Designer to come back after clicking on the Load button to bring up the table definitions in order to populate column metadata in a DB2 UDB API stage? I had experienced similar delays when importing a DB2 table definition, but was ab...

Thanks Craig -- I took a look at your related topic, and I may try that approach as well. I ended up writing all of the output to a single file, then breaking out to a shell script using sed and awk to split that file into pieces. When I get some time to revisit this solution though, I'll try the mo...

As mentioned in this previous post, I've created a Parallel job that can write to multiple files based on job parameters of brand and country, resulting in multiple files with a filename of <country>_<brand>.csv It seems I'm very close to having the solution, I just need to determine how to have the...