DSXchange

Whilw updating a hashed file using ExecTCL , in an after job subroutine , i get the following error AfterJob (ExecTCL): Error when executing command: UPDATE SOIRecordCountHash SET SOIRecordCount =21 *** Output from UniVerse command was: *** SQL How do i suppress the SQL+ prompt? Or is it something t...

Yeah, but its always easier to blame data stage and the datastage developer! Right?? There are clients that expect job sequencers containing 10 jobs to finish in 2 seconds, if not they blame the design, as well as the developer and at worst datastage. One more reason why query can be slow is the net...

Google search could be your answer Forum OpenACS Q&A: Oracle date/time interval fails with sum()Recently, I had to write queries using Oracle's new "standard" timestamp and ... ERROR at line 1: ORA-00932: inconsistent datatypes: expected NUMBER got ... openacs.org/forums/message-view?m...

I got a similar error while trying to write nulls to a hashed file. Check the data that is sourced to populate your hashed file.

The other reason could be your disk space problems

Thanks
Ramesh

Use Exec command activity that is triggered by any trigger condition via a sequencer stage. Use "dsjob -stop " command in the exec command ( Ensure that dsenv is sourced at all times) add the following lines to .profile of the data stage admin or schedule job user export DSHOME=<path to ds...

We gota cryptic error from OLE DB stage ( Microsoft SQL server) "OLE DB provider error HRESULT=0x80040e21" while inserting data to if from a data stage job After a lot of frustration , we entered the same insert statement in SQL server Query analyzer and found that we had an overflow error...

Here is a routine to execute an SQL command via an ODBC connection. $INCLUDE UNIVERSE.INCLUDE ODBC.H *** INITIALIZE VARIABLES NUM.COLS = 0 RSTATUS = 0 * DSN = "" *UID = "" *PWD = "" STMT = "drop table soi_wl_table" Ans = 0 * Check and see if user passed comman...

We had a similar 'requirement' to create a log-file.
Convinced the client it wasnt possible as data stage is an application :D . All we dd was to write warning and error messages to a log file.

If using version 7.5x , you can use mail attachment tester
Routines->Built-In-->Utilities.

It works pretty okay for some of my jobs

To clear the confusion, better refer Universe 9.6 manuals rather than 10.x.

Thanks

Like i guessed ,it was almost unnoticed
I changed the format string from to
and everything worked beautifully.

Thanks
Ramesh

The year is 4 digit and picked up from a sybase database via Stored Proc. Since SP is supplied by another team, i cannot change the same. So im trying to use modify stage to change the field data type. the input data looks like this "2004-12-20 02:33:01.147" Output should be same , but as ...

Okay i got it , the timestamp format also has milli seconds, . I changed teh format string , but i still get an error if i specify the format string . Since there are no examples on using parallel functions, im quite clueless main_program: Error parsing modify adapter: Error in binding: Parsing para...

Actually i guess im losing out on the correct syntax while passing the format string to the function. Not able to get a clue from the document either I tried sophis_changed_dt1:string[23] = string_from_timestamp["%yyyy-%mm-%dd %hh:%nn%:ss"](sophis_changed_dt) but it throws an error main_pr...

I changed the specification to

dt_1:string[23] = string_from_timestamp(dt)

and the warning has got suppressed.

how do i specify the 'timestamp_format' in

string_from_timestamp[timestamp_format] (timestamp)

Does anyone have an example?

Thanks
Ramesh