DSXchange

Hi,i am trying to Update some columns in the Sql Server table. this is the Sql i am using for update : UPDATE #s_table_His# SET OWSO11_END_BNDRY_Y = ORCHESTRATE.OWSO11_END_BNDRY_Y, OWSO11_FL_ROW_T = ORCHESTRATE.OWSO11_FL_ROW_T, OWSO11_OUT_FL_SEQ_R = ORCHESTRATE.OWSO11_OUT_FL_SEQ_R, OWSO11_RPT_GEN_ST...

looks like some issue with my Job,i recreated it from scratch and it worked fine.

Thanks.....

Hi ,
i am getting this error while i create a field "OWSO11_OUT_FL_SEQ_R" in Column Generator.

Error:
CG: Field OWSO11_OUT_FL_SEQ_R of type int32: configuration messages: Illegal value for init: .


Please help me in resolving it...

Hi All, i am facing with a space issue. i am generating a text file which has a single row entry that Row is Hardcoded as Below ---> '0000000015':READ_Data.OWSC30_MNTRY_A in the Output i.e; text file i am somehow getting a Space between the 0000000015 & 'OWSC30_MNTRY_A' FIELD. The Format i speci...

i mean to say that the other columns are getting wrong results...i mean overlapped.

Hi All, i have a Requirement for a column which i am populating as one of the output in the text file that is Generated as an output. the column name is "AMOUNT",This has to Display the 'Positive' or 'Negative' based on another field called "AMT"(if AMT >0 Positive else Negative)...

is there any way i can hardcode i.e; i am planning to Hard code as MM-25-YYYY,so for this i need to get MM ,YYYY..please let me know on How to get MM,YYYY.

Hi All,
can some one tell me On How i can populate 25th of each month i.e; i have a field(column) which has to Display 25th of the Month i.e; for eg this month it will Display 12-25-2011.

and similarly for next month -> 01-25-2012...so on

How can i code this...?

Hi ray,
THE PASSWD is not Expired as i am able to Login with the same PASSWD to my sql server from the SQL assistant to see the Data but in the Datastage i am getting an issue.

Hi Ray,

thanks for ur reply... that really solved the Problem.

i am getting this error when i run a job which is an extract job.please suggest how to avoid this error..


Error :

Could not connect to datasource[DataDirect][ODBC SQL Server Driver][SQL Server]Login failed for user 'OWSClaims_ETL_RW
>'.

hi zulfi, thanks for ur reply . the output file that is desired is a sequential file. the timestamp i get is 2011-12-07 10:07:26.527 i need to modify this to like this --> 2011-12-07-10.07.26.527 the colon(':') in time is replaced by period ('.'),please Advise how can i do this from the Column prope...

Hi, i am getting the Current time stamp from Sql Database using the following : CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) CTS the result i get is : 2011-12-07 10:07:26.527 which is correct. i want to know how can i get the following Date Format as requested by my business user. 2011-12-07-10.07.26.52...

will try.
Thnks..

Hi Thnks for ur reply.

But if i multiply by 100000000 then i will get the output as 100000000.00000000

But i dont want any value after the decimal.
All i want as 100000000 only.