DSXchange

Hello Forum, I have a job that generated many errors to do with being unable to connect to database. The last error that appears in the log is: main_program: Could not check all operators because of previous error(s ) The job is still in a run state and fails to terminate. I even sent an explicit st...

This error occurs when 7.5 manager client is used against 7.5X2 server to export modules, and then attempt to import those modules with the same client into 7.5X2 server. Solution is to install multiclient manager, and switch to 7.5X2 client while interacting with 7.5X2 server. Then complain to vend...

Hello Forum, I wish to produce fixed files with two columns of 5 bytes each (Char(5), Decimal(5)). Example of what I wish to produce: " a 1" " b 2" etc. I am reading in comma delimited input file as folows: "a,1" "b,2" etc. I also wish to have my output be in ...

Greg, you have special characters in your key field. Most likely CHAR(254) (the @FM). Use a OCONV(YourColumn,'MCP') to change undisplayable values to a period and check your data again. ... ArndW, Thanks for your response. The data unloaded from table and placed into hashed file has run before and ...

Hello Forum I received the following error: MyJobName.MYINVOCID.CntHistHash.CountHistory: ds_uvput() - Write failed for record id 'MYINVOCID 13952 SplitLoad Routing RoutingSource' Some other information about the job containing this hashed file: 1. The file is not large. (< 20MB) 2. There are no spe...

Hello Forum,

I wish to get reports of the following activities:
1. History of connections to server using the Admin Client.
2. List of view data request within Designer Client.

Is this feasible? Is there some log available I can parse through?

Thanks,

Greg

Have you tried to get the information from the developer that how he manage to make is disapear. Atleast we can try reverse engineering. :wink: It was several months ago, so it's difficult to remember. I think we were moving alot of windows around the desktop and we ended up moving the file title b...

You seem to have parked it hard on the left hand edge of the canvas. All toolbars in Designer are floating. Can you position your mouse pointer in it when it's visible? If so, try double click to s ... The title bar is never visible, even when I use an alt sequence to make a sub menu visible (Alt-F...

When pressing Alt-F or other value Alt combination from this toolbar, the submenu corresponding to that button appears on the left of the canvas. It actually appears in the same location as the Repository view. However, moving the repository view and palette out of the way does not reveal the File t...

Hello Forum, I have a developer who managed to make their file toolbar dissappear. I have tried many things to get it to re-appear, none of which have worked. The designer is fairly useless without that toolbar. Unfortunately, even a re-install did not make it reappear. By file toolbar, I mean the o...

Hello Forum, Does anybody have any experience with using 7.5X2 client with other clients on the same desktop? It appears from the vendor that it is not supported, and that the workaround is to use separate machines for different client installations where 7.5X2 is involved. Does anybody know what th...

Hello Forum, I've used project parameters ($) in transform derivations in version 7.5X2 fine. However, now I get the following error when I attempt to do the same in version 7.5.1A. Is there some limations/bugs/workarounds for such issues?: ##I TOSH 000002 14:12:31(001) <main_program> orchgeneral: l...

Hello Forum, The suggested solution above did not work for me. I plugged a Modify stage between my aggregate stage and sequential file. Sequential file has Integer (int32) column named count. Aggregate is assigning a row count to a Double(dfloat) column named count_double. My conversion specificatio...

Hello Forum, I've placed several variables like $DB_USER, $DB_NAME, $DB_PASS in my project parameter file via administrator, but when I try to use these in the Dynamic Relational Stage, I get a variety of errors including the following: TargetTable: When processing argument -inlinkpropsWhen processi...

Hello Forum, I've seen in DataStage and other ETL tools, the developer's explicitely split the transformation of load files and the loading of load files to tables into separate jobs. The main argument I've heard in favor of this, is that it simplifies the recoverability of transformation errors by ...