Before job-subroutine --> need help

G.K.K · Post by **G.K.K** » Thu Jul 30, 2009 8:25 am

chulett wrote:Ack... no-one ever mentioned using the concatenation operator and it never occurred to me you'd include the quotes after the full syntax had already been spelled out for you earlier. Oh well.

ps. Don't use the quotes that Arnd included, either.

Hi,

i tried as Arnd mentioned without quotes and concatenation. then it is showing error as Expected:Express. in the job activity stage itself.

used in job activity stage:
Excmd_file.$CommandOutput<1> ---> but showing error as showing error as Expected:Express

Thanks in Advance,
kamal

chulett · Post by **chulett** » Thu Jul 30, 2009 8:29 am

Nice... double posts 36 minutes apart. Make sure you back up and see what you've missed.

G.K.K · Post by **G.K.K** » Thu Jul 30, 2009 8:49 am

chulett wrote:Nice... double posts 36 minutes apart. Make sure you back up and see what you've missed.

hi chulett,

Thank u very very very much, it is working..

thanks for your support,
kamal.

chulett · Post by **chulett** » Thu Jul 30, 2009 9:39 am

Ah good, either way should work but as noted it can depend on your version as "earlier" versions don't support the same variety of expressions that the "later" ones do.

Please make sure you mark your post as Resolved using the big button at the top of the screen. Thanks!

G.K.K · Post by **G.K.K** » Thu Jul 30, 2009 11:23 pm

chulett wrote:Ah good, either way should work but as noted it can depend on your version as "earlier" versions don't support the same variety of expressions that the "later" ones do.

Please make sure you mark your post as Resolved using the big button at the top of the screen. Thanks!

Hi chulett,

i have a file kamal.prm which contains the below data
-----
[s_m_db2_trn_db2_EVENT_accounting_class]
$$EVENT_START_DATE=2009-07-10 09:08:18

$$DEFAULT_VALUE=''
$$DEFAULT=0
$$CONNECTOR_ID=JDBC06
$$OBJECT_NAME=HSCSP_ACCOUNTING_CLASS
$$OBJECT_VERB=Create
$$EVENT_STATUS=0
$$EVENT_COMMENT=This event is generated from Accounting_class entity
--------
now in the jobsequence in execute command stage (excmd_file_stg) i used the below unix command to read the DEFAULT variable value
grep -w "DEFAULT" /CONSIP/datasets/kamal.prm | cut -f2 -d"="

Now i am trying to send this value to job in jobactivity by setting in the parameter("k_ftch") value expression as
Convert(@FM,"", excmd_file_stg.$CommandOutput).
This parameter type is integer and used in the one of the job column (in_DEFAULT) type integer in Transformer.

But when running this sequence(job_sequence) it is throwing below error
----------------------------------------------------------------------------------
job_seq..JobControl (@Job_Activity_0): Controller problem: Error calling DSSetParam(DEFAULT), code=-4
[ParamValue/Limitvalue is not appropriate]

and sequence is Aborting...

my question is Convert(@FM,"", excmd_file_stg.$CommandOutput)
whether this convert function reads the integer value? if not how to read in integer format and send it to paramter k_ftch in job as integer?

because for character Convert(@FM,"", excmd_file_stg.$CommandOutput) this is working and giving result in the job. For reading integer it is not working.

Thanks in Advance,
kamal.

chulett · Post by **chulett** » Thu Jul 30, 2009 11:31 pm

Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is.

G.K.K · Post by **G.K.K** » Fri Jul 31, 2009 12:00 am

chulett wrote:Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is.

Hi chulett,
i am pasting the summary log that was generated by the job sequence,
my execute command stage naming conventions are ,
1.Execute_Command_EVENT_COMMENT
2.Execute_Command_EVENT_STATUS
3.Execute_Command_OBJECT_VERB
4.Execute_Command_OBJECT_NAME
5.Execute_Command_CONNECTOR_ID
6.Execute_Command_DEFAULT
7.Execute_Command_DEFAULT_VALUE
8.Excmd_file_EVENT_START_DATE

Log from sequence:
----------
job_seq..JobControl (@Coordinator): Summary of sequence run
22:50:18: Sequence started
22:50:18: Execute_Command_EVENT_COMMENT (COMMAND grep -w "EVENT_COMMENT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_COMMENT finished, reply=0
22:50:18: Execute_Command_EVENT_STATUS (COMMAND grep -w "EVENT_STATUS" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_STATUS finished, reply=0
22:50:18: Execute_Command_OBJECT_VERB (COMMAND grep -w "OBJECT_VERB" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_VERB finished, reply=0
22:50:18: Execute_Command_OBJECT_NAME (COMMAND grep -w "OBJECT_NAME" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_NAME finished, reply=0
22:50:18: Execute_Command_CONNECTOR_ID (COMMAND grep -w "CONNECTOR_ID" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_CONNECTOR_ID finished, reply=0
22:50:18: Execute_Command_DEFAULT (COMMAND grep -w "DEFAULT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT finished, reply=0
22:50:18: Execute_Command_DEFAULT_VALUE (COMMAND grep -w "DEFAULT_VALUE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT_VALUE finished, reply=0
22:50:18: Excmd_file_EVENT_START_DATE (COMMAND grep -w "EVENT_START_DATE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Excmd_file_EVENT_START_DATE finished, reply=0
22:50:18: Job_Activity_0 (JOB job2) started
22:50:18: Exception raised: @Job_Activity_0, Error calling DSSetParam(DEFAULT), code=-4 [ParamValue/Limitvalue is not appropriate]
22:50:18: Sequence failed
-----

Thanks in Advance,
kamal

G.K.K · Post by **G.K.K** » Fri Jul 31, 2009 2:05 am

G.K.K wrote:
chulett wrote:Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is.
Hi chulett,
i am pasting the summary log that was generated by the job sequence,
my execute command stage naming conventions are ,
1.Execute_Command_EVENT_COMMENT
2.Execute_Command_EVENT_STATUS
3.Execute_Command_OBJECT_VERB
4.Execute_Command_OBJECT_NAME
5.Execute_Command_CONNECTOR_ID
6.Execute_Command_DEFAULT
7.Execute_Command_DEFAULT_VALUE
8.Excmd_file_EVENT_START_DATE

Log from sequence:
----------
job_seq..JobControl (@Coordinator): Summary of sequence run
22:50:18: Sequence started
22:50:18: Execute_Command_EVENT_COMMENT (COMMAND grep -w "EVENT_COMMENT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_COMMENT finished, reply=0
22:50:18: Execute_Command_EVENT_STATUS (COMMAND grep -w "EVENT_STATUS" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_STATUS finished, reply=0
22:50:18: Execute_Command_OBJECT_VERB (COMMAND grep -w "OBJECT_VERB" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_VERB finished, reply=0
22:50:18: Execute_Command_OBJECT_NAME (COMMAND grep -w "OBJECT_NAME" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_NAME finished, reply=0
22:50:18: Execute_Command_CONNECTOR_ID (COMMAND grep -w "CONNECTOR_ID" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_CONNECTOR_ID finished, reply=0
22:50:18: Execute_Command_DEFAULT (COMMAND grep -w "DEFAULT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT finished, reply=0
22:50:18: Execute_Command_DEFAULT_VALUE (COMMAND grep -w "DEFAULT_VALUE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT_VALUE finished, reply=0
22:50:18: Excmd_file_EVENT_START_DATE (COMMAND grep -w "EVENT_START_DATE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Excmd_file_EVENT_START_DATE finished, reply=0
22:50:18: Job_Activity_0 (JOB job2) started
22:50:18: Exception raised: @Job_Activity_0, Error calling DSSetParam(DEFAULT), code=-4 [ParamValue/Limitvalue is not appropriate]
22:50:18: Sequence failed
-----

Thanks in Advance,
kamal

Hi Chulett,

can u help me in solving this...

Sorry for triubling u ..

Thanks in Advance,
kamal

G.K.K · Post by **G.K.K** » Fri Jul 31, 2009 2:06 am

G.K.K wrote:
G.K.K wrote:
chulett wrote:Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is.
Hi chulett,
i am pasting the summary log that was generated by the job sequence,
my execute command stage naming conventions are ,
1.Execute_Command_EVENT_COMMENT
2.Execute_Command_EVENT_STATUS
3.Execute_Command_OBJECT_VERB
4.Execute_Command_OBJECT_NAME
5.Execute_Command_CONNECTOR_ID
6.Execute_Command_DEFAULT
7.Execute_Command_DEFAULT_VALUE
8.Excmd_file_EVENT_START_DATE

Log from sequence:
----------
job_seq..JobControl (@Coordinator): Summary of sequence run
22:50:18: Sequence started
22:50:18: Execute_Command_EVENT_COMMENT (COMMAND grep -w "EVENT_COMMENT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_COMMENT finished, reply=0
22:50:18: Execute_Command_EVENT_STATUS (COMMAND grep -w "EVENT_STATUS" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_STATUS finished, reply=0
22:50:18: Execute_Command_OBJECT_VERB (COMMAND grep -w "OBJECT_VERB" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_VERB finished, reply=0
22:50:18: Execute_Command_OBJECT_NAME (COMMAND grep -w "OBJECT_NAME" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_NAME finished, reply=0
22:50:18: Execute_Command_CONNECTOR_ID (COMMAND grep -w "CONNECTOR_ID" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_CONNECTOR_ID finished, reply=0
22:50:18: Execute_Command_DEFAULT (COMMAND grep -w "DEFAULT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT finished, reply=0
22:50:18: Execute_Command_DEFAULT_VALUE (COMMAND grep -w "DEFAULT_VALUE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT_VALUE finished, reply=0
22:50:18: Excmd_file_EVENT_START_DATE (COMMAND grep -w "EVENT_START_DATE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Excmd_file_EVENT_START_DATE finished, reply=0
22:50:18: Job_Activity_0 (JOB job2) started
22:50:18: Exception raised: @Job_Activity_0, Error calling DSSetParam(DEFAULT), code=-4 [ParamValue/Limitvalue is not appropriate]
22:50:18: Sequence failed
-----

Thanks in Advance,
kamal
Hi Chulett,

can u help me in solving this...

Sorry for triubling u ..

Thanks in Advance,
kamal

Hi Chulett,

sorry in previous msg typo mistake..

can u help me in solving this...

Sorry for troubling u ..

Thanks in Advance,
kamal

G.K.K · Post by **G.K.K** » Fri Jul 31, 2009 2:10 am

G.K.K wrote:
G.K.K wrote:
G.K.K wrote: Hi chulett,
i am pasting the summary log that was generated by the job sequence,
my execute command stage naming conventions are ,
1.Execute_Command_EVENT_COMMENT
2.Execute_Command_EVENT_STATUS
3.Execute_Command_OBJECT_VERB
4.Execute_Command_OBJECT_NAME
5.Execute_Command_CONNECTOR_ID
6.Execute_Command_DEFAULT
7.Execute_Command_DEFAULT_VALUE
8.Excmd_file_EVENT_START_DATE

Log from sequence:
----------
job_seq..JobControl (@Coordinator): Summary of sequence run
22:50:18: Sequence started
22:50:18: Execute_Command_EVENT_COMMENT (COMMAND grep -w "EVENT_COMMENT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_COMMENT finished, reply=0
22:50:18: Execute_Command_EVENT_STATUS (COMMAND grep -w "EVENT_STATUS" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_EVENT_STATUS finished, reply=0
22:50:18: Execute_Command_OBJECT_VERB (COMMAND grep -w "OBJECT_VERB" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_VERB finished, reply=0
22:50:18: Execute_Command_OBJECT_NAME (COMMAND grep -w "OBJECT_NAME" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_OBJECT_NAME finished, reply=0
22:50:18: Execute_Command_CONNECTOR_ID (COMMAND grep -w "CONNECTOR_ID" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_CONNECTOR_ID finished, reply=0
22:50:18: Execute_Command_DEFAULT (COMMAND grep -w "DEFAULT" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT finished, reply=0
22:50:18: Execute_Command_DEFAULT_VALUE (COMMAND grep -w "DEFAULT_VALUE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Execute_Command_DEFAULT_VALUE finished, reply=0
22:50:18: Excmd_file_EVENT_START_DATE (COMMAND grep -w "EVENT_START_DATE" /CONSIP/datasets/kamal.prm | cut -f2 -d"=") started
22:50:18: Excmd_file_EVENT_START_DATE finished, reply=0
22:50:18: Job_Activity_0 (JOB job2) started
22:50:18: Exception raised: @Job_Activity_0, Error calling DSSetParam(DEFAULT), code=-4 [ParamValue/Limitvalue is not appropriate]
22:50:18: Sequence failed
-----

Thanks in Advance,
kamal
Hi Chulett,

can u help me in solving this...

Sorry for triubling u ..

Thanks in Advance,
kamal

Hi Chulett,

sorry in previous msg typo mistake..

can u help me in solving this...

Sorry for troubling u ..

Thanks in Advance,
kamal

Hi chulett,

Please help me how to convert a string value say '3' to an numeric & integer & decimal value as 3 in datastage using any functions.

if this happens then my problem solved...

i checked some typeconversion functions.. but it is giving 0 result instead of 3.

Thanks in Advance,
kamal

chulett · Post by **chulett** » Fri Jul 31, 2009 5:31 am

No, you do not need any "type conversion", your problem is all in the command you are executing. And we need to see the individual log message from when that particular Execute_Command_DEFAULT stage ran, we need details not summary information. Details.