DSXchange

Hi,

Is 22. decimal or not?. If it is a decimal how do i check?

TIA

Hi, If i convert to some delimiter like "|". How do i specify this delimiter in StartLoop Activity?. It accepts Coma,Space and Other. In the other can i directly specify "|" as delmiter or should i specify the ascii char value?. TIA If that's the intended purpose then don't conve...

Hi, Ans = Convert(@AM,Char(10),Ans) wil return the whole array as a single string?. If it return a string, How do i specify a delimiter in Start Loop Activity?.(as 10 or 0A or char(10)) any help would be apreciated. TIA No. "0A" will not be interpreted as a hex number; each @AM will be con...

how do convert that array into a single string with some delimiter or new line as delimiter character?.

Ans = Convert(@VM,"0A",Ans)

Is above works?


TIA

Hi, i wrote a routine which reads the sequential file and gives the output in a array.In this routins i have used Ans<-1> so that it reads the each record in new line. I want to pass this routine output to Start loop activity which accepts a input as a Comma,Space or other delimited string. My quest...

Hi,
can i use the merge stage, if there is no matching key column in input files?


TIA

Hi, Thanks for all for your input.But, still iam getting the error. In the merge stage iam using pure inner join.If there is no key column matches merge stage raises error like " Function 'get_next_output_row' failed [Input file : xyz.TXT] End of row termination characters expected." If ke...

Hi, I am using the Merge stage.and i have set the 'pure inner join'. Merge-------->Transformer---->seq_file. when i run this job i got an error saying that 'FUNCTION get_next_output_row' failed. [Input file : xyz.TXT] End of row termination characters expected. where do i set these properties?.any h...

Hi,

How can i debug a sequencer job?.

any help would be appreciated.

TIA

Hi,

Is StoredProcedure Stage in DS7.5 supports SQL Server StoredProcedures?.

TIA

Hi,

Iam using the following code Numeric validation.

If Oconv(Trim(InputLink.Col),"MCN") = Trim(InputLink.Col) Or Index(InputLink.Col,'E',1) >=1 Or Index(InputLink.Col,'e',1) >=1 Or InputLink.Col <>'' Then InputLink.Col Else 'Error'

Is the right approach?.

TIA

Hi,

after working for 1 or 2 weeks it gives this problem.

Sainath.Srinivasan wrote:Ensure that 'jobparameter' is a job parameter of the sequence.

Hi, I have 5 Job Activities in a sequence job.And I have declares a Job Parameter. Based on the Job Parameter value, From the job Activity1, it will trigger the Job Activity2 or Job Activity3.Here, I have written a Trigger Expression like Substrings(jobparameter,1,3)='xyz' It should trigger a Job Ac...

Hi ,
I would like count the no of lines in a text file.
Iam using the 'cat filename | wc -l' which returns the no of lines.
But Before that i need to eliminate the empty lines in the text file.
how can i achieve this?.
Any help would be appreciated.

TIA