DSXchange

What solution did you use - all that extra work using stage variables or the proper StringToTimestamp function syntax that Kryt0n helped out with? ... One which Neena provided, as i dont wanna store am/pm in table and also wanna store it in 24 hrs format.. She provided a perfect solution. But thank...

In the "Edit Row" for that column, under Properties | Nullable, add the Available properties to add: Null Field Value. Set the value to whatever that is the "exact length" as specified in the Length field. For instance, if Length=7, Scale = 2, set the value to 000000.00 (9 bytes)...

We started getting the warnings on 2 columns when we added the 2 columns to the Exclude Values | Exclude as Value in the CDC stage. The before/after you the exact same table definition. Even if all the records match (no deltas), it still issues the warnings once for each column in the Exclude list. ...

In the $dshome/../branded_odbc directory are 2 sub-directories: example and demo. In there are corresponding utility programs you can run: example and demoodbc. I use these all the time to test ODBC connection. For example: demoodbc -uid fred -pwd ethel MY_DNS_CONNECTION_NAME You can use fake userid...

we have this same error aftre a restart of the server. so user should be ok(connection was fine before restart). I however think that the restart was done incorrect, mix up between root-user and datastage-admin-user stopping and starting the processes. Could this cause this problem, and if so, how ...

We received a client-side patch from IBM for this. It is an "every other" promotion error.

Recommend opening an issue with IBM and get the benefit of your support $. Below is an e-case you can reference:

ecase 451945

Logging in with an expired unix id huh, wow, harry potter is real :o We are on AIX and do not have that "issue". If your password is expired on Unix, you don't get in. (In fact that has been true for several versions back of DataStage.) My guess is there is an environmental hole your site...

Our workplace should be "dignified and meaningful first, efficient second". --Ernst Schumacher (Hmm...Interesting choice for your signature) Please do not get hung up on semantics. As Craig noted, yes you CAN accomplish transferring a file with the FTP stage. As Ray points out, the FTP sta...

We just experienced a similar issue on a newer install. The issue was that ORACLE_HOME was not getting set properly in dsenv. (Root cause was related to /etc/oratab not having a valid entry on this server.) "dot" the dsenv ( . ./dsenv) then check the environment variables. Make sure ORACLE...

The answer for you really depends on factors for you company, such as how many jobs, how many different applications (business projects), and how you need to handle securtity. Just keep in mind other factors, such as DataStage upgrades, patches, etc, that must must do things for "every project&...

I would bet the script identifies alot of job logs that are huge. You can tie the job number of the hash file name to an actual job name using some DataStage functions. How many jobs to you have in your project(s)? Some good practices: 1) Set your jobs (in Director | Job | Clear log) to each have an...

ray.wurlod wrote:Venkat's solution will not work in a server job because the StringToDate() function is only available in parallel jobs. ...

Or omit the function call, and in the ORAOCI stage make sure the generated SQL (or you add in user-defined SQL) has the TO_DATE() function for that column.

We just went through this exercise. In addition to the multiple routines available for the various COBOL COMP formats, you can also use the CFF stage. It works GREAT! (But requires a little time to learn.) Import your COBOL copy book to save some time (I think it has to be a .cfb file, something lik...

There is also a stored procedure stage that you can put inline in your job flow.

Does anyone have any information on what approach to follow to call a webservice from datastage version 7.1? i am aware that RTI is the answer to it but of what i know, RTI is supported only from version 7.5 I do not work on datastage so i have some basic queries. I have heard that you can call a j...