DSXchange

Thanks Ray and Pratyusha...will try that and close this.

pratyusha wrote:Along with what Ray has said above maybe you need to make this job too restartable first.. So that you need not reset it

The job which needs restart is a simple Control job which checks for other job failures and resets them and starts them. The DS may be down due to undeploy/deploy services also. A 'continuous' WISD job would do this automatically. Otherwise, you'll need a 'wrapper', something to monitor it, check to...

Hi, We are trying to see if there is any way where a scheduled job (running continuously) can restart itself once the server comes up. Is there any way we can do this in datastage. Scenario: We have a job which runs continuosly. Currently, whenever the datastage server is down, the job aborts and we...

Yes, I mean running half the rows in one run and another in the second run. We tried using ODBC EE stage, but it gives the same error... I will try with DB2 EE. What do you mean by different ranges? Do you mean half the rows in the first run and the rest in the second run? What happens if you use DB...

Yes DSGUru. We tried that. also, when we tried dividing the data into different ranges, it is working, but if we pass all the data, it is not working. Did you try searching for error code "SQL0302N" in google. Try that. It seems like the input value is too large for a given column that you...

We are using ODBC Connector stage. The command is a INSERT command (generated by the ODBC connector stage based on the columns) Are you using ODBC Enterprise stage or ODBC Connector stage, Connector stage does not Open command option. Hi, I am getting the following error in datastage while trying to...

Hi, I am getting the following error in datastage while trying to insert to a table using ODBC connector. [IIS-CONN-ODBC-000004] ODBC function "SQLExecute" reported: SQLSTATE = 22001: Native Error Code = -302: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a host variable in...

Hi, I used If Num(Trim(ColA)) Then StringToDecimal(Trim(ColA)) Else 0 This seems to work fine. Thanks for the help from the forum. Have a good day... You mean to say that If IsValue(ColA) Then ColA Else Convert will work? Well looking at your input data, only the middle value would have any chance o...

You mean to say that If IsValue(ColA) Then ColA Else Convert will work? Well looking at your input data, only the middle value would have any chance of converting to an interger. '68 ' and 'NVX' are exactly interger material. You would need to do a pre validation check on your incoming value (either...

Hi,

I have an input Column of char(3) [e.g '68 ', '123', 'NVX') and need to insert it into a table with BIGINT (3).

I tried using StringToDecimal, but it doesnot work and the ODBC takes the default value 0 and inserts it in to the table.

Any suggestion?

Thanks in advance.

Basically my reqt is to calculate the prev month, year, quarter and semi annual from a given date. My input date comes like 1998-10-31 00:00:00 . It is from Sybase DB and is in timestamp format. When I am using the conversion function, I get "APT_CombinedOperatorController,0: Conversion error c...

Example => 1998-10-31 00:00:00

chulett wrote:Post an example or two of your incoming 'timestamp' values. ...

I am giving additional details: If (Month = 1) Then StringToTimestamp(Left(TimestampToString(DSLink5.PERIOD_END_DT,"%yyyy-%mm-%dd %hh:%nn:%ss"),4) : "-12" : Right(TimestampToString(DSLink5.PERIOD_END_DT,"%yyyy-%mm-%dd %hh:%nn:%ss"),12)) Else (If PrevMth < 10 Then String...

Hi, I am using StringToTimestamp("PrevYear" : "-12" : Right(TimestampToString(PERIOD_END_DT,"%yyyy-%mm-%dd %hh:%nn:%ss"),12) ) and getting the following error APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may ha...

But, we currently dont have a time dimension table and if the customer doesnot want us to go for it, then how do we derive this?

ray.wurlod wrote:This is a perfect example of where a time dimension table is the ideal solution. ...