How to specific all of values for Global Variables

Hi folks,

I assign a column to a GV and determine a specific value for this GV in running time. It works if we just would like to pull out a specific value for this column. My question is how to pull out all of records during the running time? ( If I leave the value of GV blank, 0 record will be loaded) Thanks for your help!

SAP Managed Tags:
SAP Data Services

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

MATNR = decode ($GV_MATERIAL_NUM='', MATNR, $GV_MATERIAL_NUM)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks!

This script make sense. But I got error message when I ran the job. Took it away, error would go away.

(14.2) 05-19-16 17:07:03 (R) (10168:9372) SYS-170101: |Session JB_ECC_MATERIAL_NUMBER_DATA_SQL|Work flow WF_ECC_MATERIAL_NUMBER_DATA_SQL|Data flow DF_ECC_MATERIAL_NUMBER_FIRST_LOAD

System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.

Call stack:

0x000000006C132C90, std::basic_string<unsigned short,std::char_traits<unsigned short>,std::allocator<unsigned short> >::size

0x0000000080D9580C, RdrSAPExtractor::apiOpen()+17500 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrextractor.cpp, line 2361+0029 byte(s)

0x0000000080D9896D, RdrSAPExtractor::begscan()+0909 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\reader\rdrextractor.cpp, line 1452

0x00000000801F76CC, XTran_info::restart()+0092 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\tran.cpp, line 0089

0x00000000801B3EF5, XTran_desc::restart()+0037 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0938+0013 byte(s)

0x00000000801F76BD, XTran_info::restart()+0077 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\tran.cpp, line 0087

0x00000000801B3EF5, XTran_desc::restart()+0037 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0938+0013 byte(s)

0x00000000801F76BD, XTran_info::restart()+0077 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\tran.cpp, line 0087

0x00000000801B3EF5, XTran_desc::restart()+0037 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xtran.cpp, line 0938+0013 byte(s)

0x00000000801DEC00, XDataflow_desc::executeInline()+0912 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xnet.cpp, line 1106

0x00000000801E9C7D, XDataflow_info::execute()+0925 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\net.cpp, line 0365

0x00000000801DB6C2, XDataflow_desc::execute()+0114 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\xnet.cpp, line 0843+0016 byte(s)

0x00000000801E7347, XDataflow_info::compute()+0343 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\net.cpp, line 0538+0013 byte(s)

0x00000000801E4426, XDataflow_info::compute()+0326 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\core\net.cpp, line 0658+0059 byte(s)

0x000000008007C164, AE_Main_Process_Options()+62660 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\xterniface\actamainexp.cpp, line 5379

0x000000008008D626, AE_Main()+3238 byte(s),

d:\im_ds_4.2_sp05_patch_rel\src\dataservices\dataintegrator\codeline\code\src\xterniface\actamainexp.cpp, line 1491+0036 byte(s)

0x0000000040002266

0x0000000040002ADA

0x000000004000FA90

0x00000000EAD813D2, BaseThreadInitThunk()+0034 byte(s)

0x00000000EB5254E4, RtlUserThreadStart()+0052 byte(s)

Registers:

RAX=000000000A522A80 RBX=000000000A2D1EA0 RCX=0000000000000000 RDX=00000000002131C0 RSI=0000000000000000

RDI=0000000000213950 RBP=0000000000000001 RSP=00000000002131D8 RIP=000000006C132C90 FLG=0000000000010246

R8=00000000002131A0 R9=0000000000000000 R10=000000000A03E20E R11=000000000A03E20E R12=0000000000000000

R13=00000000037FDD10 R14=000000000A522890 R15=000000000A601810

Exception code: C0000005 ACCESS_VIOLATION

Fault address: 000000006C132C90 01:0000000000001C90

C:\Windows\WinSxS\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.8428_none_88dcdb0b2fb19957\MSVCP80.dll

==========================================================

Collect the following and send to Customer Support:

1. Log files(error_*, monitor_*, trace_*) associated with this failed job.

2. Exported ATL file of this failed job.

3. DDL statements of tables referenced in this failed job.

4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when

the job failed.

5. Core dump, if any, generated from this failed job.

==========================================================

(14.2) 05-19-16 17:07:03 (E) (10168:9372) SYS-170101: |Session JB_ECC_MATERIAL_NUMBER_DATA_SQL|Work flow WF_ECC_MATERIAL_NUMBER_DATA_SQL|Data flow DF_ECC_MATERIAL_NUMBER_FIRST_LOAD

桔⁥祳瑳浥攠据畯瑮牥摥愠⁮硥散瑰潩⁮湡⁤慣湮瑯瀠潲散獳琠楨⁳捡楴湯‮桔獩洠獥慳敧挠湯

慴湩⁳潳敭椠瑮牥慮⁬祳瑳浥搠瑥楡獬眠楨档栠癡⁥敢湥栠摩敤⁮潦⁲敳畣楲祴‮晉礠畯渠敥⁤

潴猠敥琠敨映汵⁬潣瑮湥獴漠⁦桴⁥牯杩湩污洠獥慳敧‬獡⁫潹牵愠浤湩獩牴瑡牯琠⁯獡楳湧愠

摤瑩潩慮⁬牰癩汩来獥琠⁯潹牵愠捣畯瑮.

(14.2) 05-19-16 17:07:13 (E) (10168:9372) EML-160202: |Session JB_ECC_MATERIAL_NUMBER_DATA_SQL|Work flow WF_ECC_MATERIAL_NUMBER_DATA_SQL|Work flow WF_UPDATE_EXCEPTION_HANDLER_SQL

Failed to communicate with SMTP server on <QUIT> command. Try to run it manually to see the actual error.

A core dump? There must be another reason why, I am afraid.

You know, this has always worked for me. And it still does. Just tested.

Ask a Question

Top Q&A Solution Author

User

Count