DSXchange

Are they really blanks (Char(32))? Use an editor that allows you to see exactly what character is in the second field in the seq file. Trim() function with one argument definitely does remove blanks. Check the help to learn that it can trim any character. If Column2 really is defined as VarChar (in ...

Craig, Im using SQL Server and its a lot more usable. We use it to check for hash file conflicts across jobs. Have written some sql if that is of any use. Peter -----Original Message----- From: Craig_Hulett@rsausa.com To: datastage-users@oliver.com Sent: 5/1/02 6:30 AM Subject: Documentation Tool An...

Anybody use this thing? Anybody using something other than Access for its database? I pulled a job into it in the hopes that I could generate a report to double-check some changes I had just made. Much to my surprise, the report it generated was almost *200* pages long. Waaaay too much detail. I the...

I extracted the DB2 data to a seq file, using Trim(column2) to trim the leading and trailing blanks. Column2 is defined as varchar. I just cant get rid of the trailing blanks. TrimB doesnt work also. Any idea. "S","SCRAP TAG ","A","1994-06-06 12:38:24","2002-04-30 10:35:00","N","PHL", Thanks, - Yiming

unlock the job in the DSAdministrator or wait a while (it will unlock itself) Kasia At 03:17 26/04/2002, you wrote: >Sorry guys, just got back using DataStage again after quite a while and >I >forgot how to do this thing. > >I was running a job and was suddenly disconnected from the network. >When >...

Hi Susan, No, we dont MetaStage proxy mode checked. Doris Susan McNally wrote: > > Hello Doris, > > The error message looks like it is related to MetaStage. > > In Adminsitrator, do you have "Operate in MetaStage Proxy mode" > checked? > > Susan. > > -----Original Message----- > From: Doris Zammit [...

Thanks Ray I have changed all parameters in uvconfig file that contain MS1252 value on MS1251 and it helps. Best regards,Alexandre Stoulov ------------------------------ Consultant. Business Intelligence Projects TERN Company mailto:alexs@tern.ru RW> If youre creating the text file, it will inherit ...

This is a message from the DataStage BASIC program ORABULK.RUN (the ORABULK stage is written in DataStage BASIC). What it means is that the test2.dat file could not be opened for writing because another process has it update-locked. This might result from an existing, running job or from an aborted ...

Im getting a following error, while running my job. Any info?? ORABULK.RUN(Job123.abc123)ORABULK.OPEN: OPENSEQ /devl/appl/data/output_files/test2.dat took LOCKED clause with STATUS()=-1 DateStage: 4.2 Oracle: 8 System: Unix Thanks in advance RL _______________________________________________________...

If youre creating the text file, it will inherit the default file map (from the configuration file uvconfig). It appears that your default O/S file map is not one that handles the Russian characters correctly. In your DataStage BASIC program you can override the default file map by executing the com...

Hello Doris, The error message looks like it is related to MetaStage. In Adminsitrator, do you have "Operate in MetaStage Proxy mode" checked? Susan. -----Original Message----- From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us] Sent: Tue 30/04/2002 4:58 a.m. To: datastage-users@oliver.com Cc: ...

Hello

We are trying to write to DB/400 (V4R5) with DB2 Connect ver. 7.2, it only work with 1 in transaction size in DataStage. Are there anyone who knows what to change on our AS/400 to commit more than one row at time ?


Thanks,
Bo

sounds like the ODBC Data Source is not pointing to the correct place. OR the data source is referencing a database not defined in your ODBC Stage or in DS Manager -----Original Message----- From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us] Sent: Monday, April 29, 2002 2:58 PM To: datastage-u...

Hello Everyone, We are trying to write a large file (over a million records) from a hashed file to a SQL Server database through an ODBC connection and we get this error: DSD_SendEvent.B:Error Starting run Cmd = SH -cActivityCmd START -file MSEVENTS/20020429143733477 Output = ERROR: Couldnt get I/O ...

Hi, guys! Please explain me how DS (NLS enabled) writes records to log file and how can I read that file. I have a simple job that write some russian characters to its log file. I write a routine that reads this log file (just for test purpose): Function ReadLog(arg1) Ans = TRANS("RT_LOG84", 6, 5, "...