DSXchange

I used the code below in my transform to figure out what the correct value should be and make it precision = 2: If Num(myField) And Index(myField, "E", 1) = 0 Then OCONV(myField, "MD2P") Else OCONV(FIELD(myField,"E",1)*(10 ^ (FIELD(myField,"E",2)+2)),"MR2...

I did both searched but it didn't give me what I need. I did however figure it out on my own.
Thanks.

Hi, I am loading a csv file to a SQL table and ran into a problem where one of the records has a column that has a decimal value but in scientific notation: 1.7588676455E7 The datatype of the column is decimal(18,2) both in DS and SQl table. How can I convert this number to a regular decimal that it...

Redirect the output to a file, then check the file. ... Thanks, do you, by chance, have a sample how to check the file, how do I parse it? Here is what the file has: Job Status : RUN OK (1) Job Controller : not available Job Start Time : Tue Apr 15 11:24:43 2008 Job Wave Number : 7 User Status : no...

Hi, I created a batch file in windows that runs a DS job. I want to check the status of the job and then decide whether a reset is needed. I am having trouble capturing and reusing the result of the status in a variable. Here is my code: REM GET status info %DSJOBPATH%\dsjob -jobinfo %PROJECT% %DSJO...

Actually I just got it to work .. .Now I need to enhance this line to add -param values. However I have environment variables as parameters. What would the syntax be for this: variable: $envLoadDateTime value: 2008-04-14 12:00:00 would I put $envLoadDateTime=2008-04-14 12:00:00 in quotes? "$env...

I changed it but still same error

It "should" but doesn't always work without it. try with whatever user/pwd you would use with the client. ... Added username and password but still doesn't work. See below: E:\>e:\Ascential\DataStage\Engine\bin\dsjob -run NORMAL -wait -server FTLDETL01 -user juls -password s1203 ENTERPRIS...

chulett wrote:Does it work if you pass in full credentials - server, username and password? Or just the server? ...

It doesn't work when I add server. When you say user name and password? Which are those? I am an admin on the box.. shouldn't it run under my credentials?

Hi, I read all the posts on this but still seem to be having problem I am running the following code in my batch file but get an error: project = ENT_DWH job=seq_STAGING e:\Ascential\DataStage\Engine\bin\dsjob -run NORMAL -wait ENT_DWH seq_STAGING -param '$envLoadDateTime=2008-04-14 12:00:00' Invali...

Thank you. Appreciate the follow up. I contacted IBM and waiting on their response.
We do not have Java Pack now, unfortunately.

Yeah.. another option for us would to use a data loader but I have been tasked with making the call using web service stage.

Has anyone had any success using DS web service pack with calling SalesForce.com web services?

Thanks.

Kris,
I found your post about the patch and searched Ascential's knowledge base for both dll name and "nested condition" but came up with nothing relevant. Can you please find the ecase number you used?

Thanks.

Yes, I have other jobs which use a Nested Condition Stage. However, they do not make a call to a transform. They just look at the result of another stage.