DSXchange

Hi, I have a server job Seq file read -> transformer-> o/p seq file. Data contains ... "HE GARDENER'S COTTAGE" Server job aborts saying STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE"," the 'S in the data is a problem. If I...

Hi, I have a server job Seq file read -> transformer-> o/p seq file. Data contains ... "HE GARDENER'S COTTAGE" Server job aborts saying STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE"," Is this to be specially handelled? Th...

I restarted the server and the error is gone, but what was the error and why it came , I am still clueless.

Any ideas?

Hi, We get the following message when we try to open DS designer or DS administrator DSR.ADMIN : cannot open UV_USER STATUS ()=-9 then we click ok, it says ACCESS DENIED: Internal SQL error failed to register thus user for SQL. There has been no changed at user level or anything. Can anyone guide wh...

I dint mention, if i select any other column its not giving error, that is why I thought its sumthing to do with the column name and the "-" in it

Thanks,

Hi, I am selecting a column called "Match-type" using ODBC stage from progress database. I get [OpenLink][ODBC][Progress Server]Syntax error (7587). is the "-" hyphen causing problem? I read "Server and Parallel Jobs Column names can be any length. They must begin with an al...

Thanks for your responses. I am now trying to do same thing.. aggregate seperately then using transformer (pseudo join key) join all aggregator data then cat the main file and the last line. chulett, if I try your logic.. and cat, i will get each sum as a seperate row, i need the sum columns side by...

Hi, I want to print sum of some of the columns as the last row whcih shows the total of all the data coming in a particular column. for eg LA Vol1 Date Vol2 Vol3 Status A 10 23/Feb/2008 5 10 F B 20 23/Feb/2008 5 10 F C 10 23/Feb/2008 5 10 P D 30 23/Feb/2008 5 10 P 4 70 20 50 The last row gives the t...

Hi,

I got it, took the stage variable as varchar2 SvDate

SvDate= (CurrentDate() [1,2] : PAR_ERT_YY)-1

as simple as that..


Thanks anyways.

Hi, I took a stage variable SvDate as date and SvDate=StringToDate(CurrentDate() [1,2] : PAR_ERT_YY,"%yyyy")-1 where PAR_ERT_YY will have value of year for eg 08. Then in the OUT column i use SvDate. But still I get the same error Invalid conversion requested from a dfloat to a date. Why i...

Hi, I took a stage variable SvDate as date and SvDate=StringToDate(CurrentDate() [1,2] : PAR_ERT_YY,"%yyyy")-1 where PAR_ERT_YY will have value of year for eg 08. Then in the OUT column i use SvDate. But still I get the same error Invalid conversion requested from a dfloat to a date. Why i...

Hi, I have a string for eg 08. I need to convert it into year and get the previous year. I tried OUT=DateToString((StringToDate(PAR_ERT_YY,"%yy")-1)) and OUT column is a varchar (2). I get an error while compiling... Invalid conversion requested from a dfloat to a date. Can anyone help me ...

Hi, We are connecting to Progress d/b using ODBC stage. There are around 10,00,000 records to be read and put into a dataset. I am getting the following error after a read of around 6,00,000 records. The timeout happens for any number of records...say if the records are more than 3,00,000 not for le...

Hi Ray, How can we pass the invocation id if i am running the job from the command prompt like dsjob -run -jobstatus -param <parameter list > <project name> <job name> If we create a new parameter for the invocation id... where do I pass it. I could not find this documented in the online doc. It tel...

Hi Ray, How can we pass the invocation id if i am running the job from the command prompt like dsjob -run -jobstatus -param <parameter list > <project name> <job name> If we create a new parameter for the invocation id... where do I pass it. I could not find this documented in the online doc. It tel...